Cloudera Community
ssubhas
user rank
user rank
Guru

Re: Error: Error while processing statement: FAILE...

by Guru Guru in Support Questions
‎07-13-2016 12:11 PM
3 Kudos
‎07-13-2016 12:11 PM
3 Kudos
@chennuri gouri shankar Can you please check /etc/security/limits.conf and the check the configuration for the user running beeline? Try to increase the nofile & nproc and see if it helps. Thanks and Regards, Sindhu ... View more

Re: Migrate Hive Metastore from MySQL to Postgres

by Guru Guru in Support Questions
‎07-13-2016 11:37 AM
‎07-13-2016 11:37 AM
@Rinku Singh Did you try running schematool to upgrade Metastore? For example: $ /usr/hdp/current/hive-metastore/bin/schematool -upgradeSchema -dbType mysql Thanks and Regards, Sindhu ... View more

Re: beeline is there -i option?

by Guru Guru in Support Questions
‎07-11-2016 05:22 PM
‎07-11-2016 05:22 PM
@Sunile Manjee As of now, there is no option to initialize the beeline. Hive Jira 5867 is related to this feature: https://issues.apache.org/jira/browse/HIVE-5867 Thanks and Regards, Sindhu ... View more

Re: Can we downgrade spark version from 1.6 to 1.5...

by Guru Guru in Support Questions
‎07-11-2016 06:06 AM
‎07-11-2016 06:06 AM
@revan wabale It is not recommended to downgrade Spark from 1.6 ot 1.5 as 1.5 is not tested with HDP 2.4.2 and might lead to issues. Thanks and Regards, Sindhu ... View more

Re: sqoop error

by Guru Guru in Support Questions
‎07-06-2016 10:42 AM
‎07-06-2016 10:42 AM
@Geoffrey Shelton Okot This is due to permission issue, please do the following: su - hdfs hdfs dfs -chown -R sqoop:hdfs /user/root Then run sqoop command. Thanks and Regards, Sindhu ... View more

Re: Tez session hasn't been created yet. Opening s...

by Guru Guru in Support Questions
‎07-05-2016 07:56 AM
‎07-05-2016 07:56 AM
@Daniela Boamba Can you share Resource manager log and Hive server 2log for analysis? ... View more

Re: Tez session hasn't been created yet. Opening s...

by Guru Guru in Support Questions
‎07-05-2016 07:25 AM
‎07-05-2016 07:25 AM
@Daniela Boamba That means the issue is with Tez alone not Resource Manager. Can you please check if the Tez client is installed or not? Thanks and Regards, Sindhu ... View more

Re: Tez session hasn't been created yet. Opening s...

by Guru Guru in Support Questions
‎07-05-2016 07:12 AM
1 Kudo
‎07-05-2016 07:12 AM
1 Kudo
@Daniela Boamba Can you try running the insert query after changing execution engine to mr? set hive.execution.engine=mr; Thanks and Regards, Sindhu ... View more

Re: How does --hive import work

by Guru Guru in Support Questions
‎07-01-2016 08:15 AM
1 Kudo
‎07-01-2016 08:15 AM
1 Kudo
@Simran Kaur If you have a Hive metastore associated with your HDFS cluster, --hive-import and -hive-overwrite always writes to Hive warehouse directory. Arguments like --warehouse-dir <dir>, --as-avrodatafile, --as-sequencefile, --target-dir etc. are not honoured. Thanks and Regards, Sindhu ... View more

Re: How does --hive import work

by Guru Guru in Support Questions
‎07-01-2016 07:38 AM
‎07-01-2016 07:38 AM
@Simran Kaur --target-dir is the while importing table data into HDFS using the Sqoop import tool and might not work with --hive-import. As @Dileep Kumar Chiguruvada explained earlier, the value of Hive warehouse directory will be picked from hive-site.xml. Thanks and Regards, Sindhu ... View more
Contact Me
Online
Offline
Last Visited
‎06-08-2020 12:38 PM
Community Statistics
Member Since ‎04-11-2016 05:12 AM
Last Visited ‎06-08-2020 12:38 PM
Posts 535
Kudos received 147