About deepesh1

deepesh1 · ‎03-27-2018

The process owner for Hive LLAP daemon process has to be the same as the query executing user. When Hive Server Interactive (aka HSI) is brought up by Ambari, the LLAP daemons are owned by user hive. The executing user will also need to be hive which is what happens when hive.server2.enable.doAs is false. The intended usage of HSI is to be with impersonation disabled (hive.server2.enable.doAs=false). The end user authorization is assumed to be handled by Ranger Auth or SQL Standard Auth.

deepesh1 · ‎11-03-2017

Hive 2 is not exposed as a service that you add during install. It gets deployed and configured from the Hive config screen. To enable, go to the Hive config screen and flip the "Enable Interactive Query" slider. It will then bring up a popup and guide you through the configuration.

deepesh1 · ‎10-20-2017

This may be due to HDFS default replication set to 3. So the total space requirement would be 800GB * 3 = 2.4TB which exceeds 2.3TB that's available.

deepesh1 · ‎10-17-2017

The support matrix lists the OS that are officially supported, this means that they have gone through extensive deployment and certification testing. Choosing an OS for official support has criterions including the user/customer adoption, expect it in the upcoming update release on HDP-2.6.x. You can still go ahead and use the centos6 repo to install on CentOS 6.9 but Hortonworks will not officially support it.

deepesh1 · ‎09-26-2017

Have you given that a try, setting hive.metastore.warehouse.dir in hive-site.xml under spark conf.

deepesh1 · ‎09-26-2017

The property you want to change is "hive.metastore.warehouse.dir".

deepesh1 · ‎09-26-2017

Can you post the application log from the failed application application_1506422992590_0008? You can collect that by running yarn logs -applicationId application_1506422992590_0008 > app_logs.txt

deepesh1 · ‎09-22-2017

Reading Hive ACID ORC data has some issues, it seems the data is not visible unless you compact the table atleast once, see SPARK-16996. Hive ACID tables ORC data operations are currently not supported from Spark, see SPARK-15348.

deepesh1 · ‎09-18-2017

Typically BigSQL should be installed on 3 nodes at minimum, with BigSQL Master node on one node and BigSQL worker node on the other two. Also establish passwordless ssh for root user from BigSQL master node to the worker nodes. You can find detailed instructions from IBM BigSQL Install document. Make sure that the pre-requisites are followed before installing BigSQL.

deepesh1 · ‎09-18-2017

How many rows are you expecting from the output of this query? Beeline client in its default setting is prone to memory issues when large number of rows get fetched as it buffers all rows in memory. The workaround is to use the following argument when starting beeline. --incremental=true HIVE-7224 which was recently fixed will make that setting as default but for now you will need to use the above argument to beeline client. More documentation on that option and others is on Hive Wiki.

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: Hive LLAP has conflict with Impresonation (run...

Re: Hive 2 is missing after HDP upgrade

Re: DiskSpace quota exception on hive

Re: Is Hortonworks HDP 2.6.0 supports Centos 6.9

Re: How can I change hive warehouse directory fro...

Re: How can I change hive warehouse directory fro...

Re: Export from HDFS to mysql using Sqoop

Re: Query hive acid with spark

Re: Add Service - BigSQL fails

Re: Hive -org.apache.thrift.TException: Error in c...