About deepesh1

deepesh1 · ‎12-11-2015

Did the file Batting.csv get copied over to HDFS? Can you do a hadoop fs -ls /user/quest? Potentially could be a file not existing issue or permission issue.

deepesh1 · ‎12-11-2015

Are you using Transparent Data Encryption on HDFS?

deepesh1 · ‎12-11-2015

Just elaborating on my above comment which @Emily Sharpe has already verified as the workaround. The issue is in the Vectorization code path, see Apache Hive JIRA HIVE-8197, the issue should be fixed in both HDP 2.2.x and HDP 2.3.x. The workaround is to disable vectorization by setting hive.vectorized.execution.enabled = false.

deepesh1 · ‎12-10-2015

Can you try the same with hive.vectorized.execution.enabled = false?

deepesh1 · ‎12-07-2015

I can tell you that for our System Testing we certify MySQL 5.6 which is what the documents as pointed out by @Neeraj Sabharwal say.

deepesh1 · ‎12-04-2015

A workaround for this could be launching the hive cli in the following manner: hive -hiveconf hive.execution.engine=mr But this would mean that if you want to run any queries in tez you would need to run "set hive.execution.engine=tez;" before running your queries.

deepesh1 · ‎11-25-2015

What client are you using to run the query? If its Hive CLI then you can run export HADOOP_OPTS="-Xmx2048m" on the shell and then invoke the hive cli.

deepesh1 · ‎11-24-2015

Did you run both table level and column level statistics: analyze table t compute statistics; analyze table t compute statistics for columns; The log will be the hive client log (/tmp/<user>/hive.log) in case of hive cli, for hiveserver2 it will likely be /var/log/hive/hiveserver2.log (whatever you configured in Ambari).

deepesh1 · ‎11-20-2015

For HDP 2.2.4 you should use Teradata v1.3.4 connector.

deepesh1 · ‎11-20-2015

If its just a migration, you can make a copy of your old database and then point the HDP 2.3.2 cluster to the copy of your old database. Before starting the Hive services upgrade the hive database by using schemaTool. You can use metatool to update the HDFS locations to the new cluster. Start the hive services.

Online	Offline
Last Visited	‎05-09-2018 06:03 AM

Member Since	‎09-25-2015 05:14 PM
Last Visited	‎05-09-2018 06:03 AM
Posts	356
Kudos received	379

Cloudera Community

Re: Hive 2 is missing after HDP upgrade

Re: Is Hortonworks HDP 2.6.0 supports Centos 6.9

Re: Add Service - BigSQL fails

Re: hi , I am having trouble connecting to beeline...

Re: Hive Metastore throws a null pointer exception

Re: Failed to read data from "/user/guest/Batting....

Re: Data Encryption and Decryption across the sour...

Re: Bug in Hive (HDP 2.1), Timestamp data overwrit...

Re: Bug in Hive (HDP 2.1), Timestamp data overwrit...

Re: MySQL 5.7 Support?

Re: Is there a way to prevent the start of the Tez...

Re: Hive increase map join local task memory

Re: Hive Explain says "Plan not optimized by CBO d...

Re: Connecting Teradata to HDP 2.2.4

Re: how to migrate Hive data over to new cluster?