Member since
12-19-2017
2
Posts
0
Kudos Received
0
Solutions
01-18-2018
12:16 AM
Hi, i´m trying to use sqoop via hue, but i keep getting this error: 2018-01-18 08:31:52,353 [main] WARN org.kitesdk.data.spi.hive.MetaStoreUtil - Aborting use of local MetaStore. Allow local MetaStore by setting kite.hive.allow-local-metastore=true in HiveConf
2018-01-18 08:31:52,353 [main] ERROR org.apache.sqoop.tool.ImportTool - Import failed: Missing Hive MetaStore connection URI Its not the same but seems to be quite similar. The cluster is useing HA for Hive metastore. I tried to set the Hive metastore uri like this: import -Dhive.metastore.uris=thrift://17.239.167.168:9083 -Dkite.hive.allow-local-metastore=true --connect jdbc:exa:17.239.167.201..205:8563;schema=sks_dp_steuerung --driver com.exasol.jdbc.EXADriver --username sys --password exasol --table dbo_institutspartitionen --hive-import --as-parquetfile --hive-table DBO_INSTITUTSPARTITIONEN --hive-database SKS_DP_STEUERUNG -m 1 but it makes no difference. The Exception tells to set kite.hive.allow-local-metastore=true I tried this via -Dkite.hive.allow-local-metastore=true I have no idea whether this would be the right way to do this. Is there something i might have missed? Or is this really a completely different error?
... View more
12-19-2017
02:37 AM
Hi, There are some internal Jira's that have been raised for the Sqoop + Parquet + --decimal to make the import happen perfectly fine without changing the datatype by Sqoop. But untill that Jira is fixed we have to change the data type. Regards Nitish
... View more