I have set up a connection between Dataiku and Hive using an Apache Hive JDBC driver. When I select the "Import tables to dataset" option at the bottom of the connection, I can select a table and impo…
Thanks - although the issue is that I didn't write the query, Dataiku generated it automatically when I selected "Import tables to dataset". Based on Clement's answer, I think the best approach is to scrap the Hive JDBC connection altogether.
Hi, I am evaluating DSS, so I installed it in my server and added a 2 weeks enterprise trial license. I am facing a Cloudera CDH 5.12 cluster, kerberized. I am able to connect and browse HDFS, but Hiv…
It looks like you have added a "Connection property" in the Hive connection settings (in Administration > Settings > Hadoop) but didn't fill anything in the key. You will need to either make sure the property is filled or remove it.
Hi, I get this message from a hive recipe on a partitioned dataset stored on HDFS: validation failed: Cannot insert into target table because number/types are different "2018-02": Table inclause-0 has…
I have a shell script which appends a Hive table (overwritten on every run of the workflow) to a Hive archive table. However, on occasion, the first Hive table is empty, which is breaking the workflow…
Hi, In our project we are loading input file into Hive tables using DSS and build summary tables on top of it which are used by tableau. We are using Python recipe which will create HIve table based o…
DSS 4.0 When trying to synchronize the metastore, I get this error: [18:20:40] [ERROR] [org.apache.thrift.transport.TSaslTransport] running compute_sfpd_incidents_sample_prepared_NP - SASL negotiation…
We have 2 tables with the same name in different DSS projects, and we only see one table with the name in the Hive metastore. It seems that when tables are synced in DSS to a Hive Metastore, the DSS p…
Hi, I'm trying to use a UDF in a hive recipe, I've seen the additional configuration line where I can add a key and a value Can I put there : add (as key?) and /thepathtomyudf.jar (as value?) ? Or is …