-
Oracle - create and use a "macro" variable
Hi, I'm far from being a SQL expert, so i'm going to try to explain my issue as well as possible : I have a list of IDs (in a csv file for example) and i want to get different information about them that are stored in many different oracle tables. So everytime I call a table, I want to be able to do something like that :…
-
COnnecting to SQL server from a Docker enabled DSS
Hello ! I'm trying Dataiku Enterprise and trying to connect to a SQL server. I downloaded the driver thanks to https://doc.dataiku.com/dss/latest/installation/jdbc.html My DSS in installed in a Docker container, following this page https://www.dataiku.com/learn/guide/tips/dss-windows-docker.html The error message I got is…
-
How can I create a materialized view in DSS and use it in the flow ?
I have few tables in postgreSQL and I want to make a materialized view for a complex join query.
-
PostgreSQL: FULL OUTER JOIN with partitioned tables
I have 2 datasets (PostgreSQL) to join: "input1", "input2" and the result should be "output". All datasets are partitioned by date. How to make a FULL OUTER JOIN and keep the partition?
-
Full outer join
Is there a way to do a full outer join between to datasets stored in the DSS memory (so basically made by recipes or analyses) ?
-
FULL OUTER join not available with MySQL datasets
Hello, I'm trying to use a FULL OUTER join in a recipe between 2 MySQL datasets. The option is not available while it appears that it should: "Not available in this mode, use a SQL or Hive database to use FULL OUTER joins." Keep up, William
-
Load from HDFS to Oracle
When inserting data from HDFS to Oracle or another supported database such as Greenplum, does the data flow through the DSS server (memory)?
-
Error on import for a SQL Query in a python recipe
Hello, I'm trying to make some SQL query directly from a python recipe to make some work in python on the results. I followed the advice from this page : http://doc.dataiku.com/dss/latest/api/python/sql.html But I get the following error, as soon as I try to import SQLExecutor, any idea what's the problem ?…
-
failed to create a table in oracle through dss
Hello, In order to create a table in oracle, i've created a new dataset. When I fill the filed Table and Schema, it automatically generate this sql statement: CREATE TABLE "dsa"."piv_obj" (...) Wich generate the following error: ORA-01918: user 'dsa' does not exist Because of the " between the username. Thks in advance,
-
MySQL timezone error ?
Hi, I can't read my dataset on mysql, I have the error: Failed to run java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if…
