Found some new info in latest Cloudera CDP guides for Impala. It would be nice if they made Hive and Impala more similar for SQL standard syntax but unfortunately it is not same: https://docs.cloudera.com/runtime/7.2.14/impala-sql-reference/topics/impala-identifiers.html Impala identifiers Provides information about using Identifiers as the names of databases, tables, or columns when creating the objects. The following rules apply to identifiers in Impala: The minimum length of an identifier is 1 character. The maximum length of an identifier is currently 128 characters, enforced by the Metastore database. ... View more

Seems like your cluster is configured with default impala admission control control. Please create and setup new impala admission control control with the correct parameter based on the how much queries need to executed and resources you have  ... View more

Hi, may this cause failure of the job ? Thanks. ... View more

@manikala  as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

Thanks for the confirmation @syedshakir. Much appreciated.  ... View more

You can find the error message 'Index build failed for service hdfs' in RM log. This issue is caused by exceptional ' /var/lib/cloudera-scm-headlamp/' where the Reports Manager role is configured to run.   step 1: stop CMS Reports Manager role   step 2: RUN THIS ON THE HOST WHERE RM ROLE RUNS sudo rm -rf /var/lib/cloudera-scm-headlamp/*   step 3: start CMS Reports Manager role (will rebuild the headlamp dir)   Done.   You can now use CM> HDFS> File Browser. ... View more

I have the same issue with the latest SQL Developer sqldeveloper-20.4.1.407.0006-x64.zip which has bundled JDK. Use the latest version of Cloudera JDBC driver for today (hive_jdbc_2.6.15.108.zip) to be precise 4.1. Hive 3.1 goes as a component of HDP 3.1 ... View more

1. Is there any way to change font size, color. 2. when performing export upload to spreadsheet, I would always want to include the query that produced the result. Currently I have to do this manually. ... View more

Test 2 ways:   1.- Increase the Java Heap Size of HiveServer2   Go to Hive service. Click the Configuration tab. Search for Java Heap Size of HiveServer2 in Bytes, and increase the value.  Click Save Changes. Restart HiveServer2.   2.- In Hive >  Configs > Custom hive-site.xml, add the following:       hive.metastore.event.db.notification.api.auth=false ... View more

Hi @EricL    This happens due to the hive server is not working or stopped due to some problem.   Restart the hive server with the below command and try again.   hive --service hiveserver2 &   Regards, Dhirendra  ... View more