About ssubhas

ssubhas · ‎07-01-2016

@Simran Kaur Can you please check the hive table created using describe formatted <hivetablename> and check the location of the hive data? It seems like data is being written to different directory and with --warehouse-dir not taking effect. Thanks and Regards, Sindhu

ssubhas · ‎06-29-2016

@Jan Kytara Can you please share the table definition?

ssubhas · ‎06-28-2016

@ARUNKUMAR RAMASAMY The jars need to be present on the Hiveserver machine. It is not necessary to have them on all the nodes. You can refer to below link: http://stackoverflow.com/questions/31802908/adding-hive-jars-permanently/31808016 Thanks and Regards, Sindhu

ssubhas · ‎06-27-2016

@Ethan Hsieh Have you run import-hive.sh? From where the tabled were created?

ssubhas · ‎06-27-2016

@ARUNKUMAR RAMASAMY You can import data into underlying hbase table of phoenix, but data cannot be seen from phoenix. Sqoop Jira SQOOP-2649 for sqoop-phoenix integration is addressed on Sqoop 1.4.7. https://issues.apache.org/jira/browse/SQOOP-2649 Thanks and Regards, Sindhu

ssubhas · ‎06-27-2016

@Ethan Hsieh Issue seems to missing gson.jar in the AUX path. Please check and download the gson jar from the below link: http://www.java2s.com/Code/Jar/g/Downloadgson222jar.htm Hope this helps. Thanks and Regards, Sindhu

ssubhas · ‎06-24-2016

@jihed chokri Please try following: Login to Hive Cli. Run command set mapred.job.queue.name=<queue_name>; Run command set hive.execution.engine=mr; Run the query. Thanks and Regards, Sindhu

ssubhas · ‎06-24-2016

@jihed chokri Set the queue name in the hive cli and beeline as below: set set mapred.job.queue.name=<queue_name>; Or under hive-site.xml as property: <property> <name>mapred.job.queue.name</name> <value>queue_name</value> </property> Thanks and Regards, Sindhu

ssubhas · ‎06-23-2016

Please mark the best answer to close the discussion.

ssubhas · ‎06-23-2016

yes, that's right.

Online	Offline
Last Visited	‎06-08-2020 12:38 PM

Member Since	‎04-11-2016 05:12 AM
Last Visited	‎06-08-2020 12:38 PM
Posts	535
Kudos received	147

Cloudera Community

Re: What does --m 1 represent in sqoop import sta...

Re: HDP-2.6.4.0 - Superset startup failes with err...

Re: Unable to import data from Informix non transa...

Re: We have an AWS cluster setup for HCP Metron a...

Re: HDP support for Sqoop 2.x ?

Re: How does --hive import work

Re: Hive corrupting or displaying data corruptly

Re: hive auxillary jars

Re: Hive Hook Error: NoClassDefFoundError: com/goo...

Re: sqoop import to a phoenix table

Re: Hive Hook Error: NoClassDefFoundError: com/goo...

Re: CREATE TABLE geolocation STORED AS ORC AS SELE...

Re: CREATE TABLE geolocation STORED AS ORC AS SELE...

Re: Can we take user input in hive

Re: Can we take user input in hive