Try running invalidate metadata; At end clearing browser cache worked for me. ... View more

Hi  Nagaraj/ Anyone Can you please share the steps if you remember ?  ERROR org.apache.hadoop.hdfs.server.namenode.ha.StandbyCheckpointer: Exception in doCheckpoint java.io.IOException: Exception during image upload: java.lang.NoClassDefFoundError: org/apache/http/client/utils/URIBuilder Caused by: java.lang.NoClassDefFoundError: org/apache/http/client/utils/URIBuilder ... View more

sqoop-list-databases \ > --connect "jdbc:mysql://quickstart.cloudera:3306/retail_db" \ > --username retail_dba \ > --password cloudera \ ... View more

Usually, ​ Exception: java.io.IOException: Exceeded MAX_FAILED_UNIQUE_FETCHES; bailing-out  is caused by communication issues among Hadoop cluster nodes.   To resolve this issue, check the following:   a) Whether there are any communication problems among the Hadoop cluster nodes. b) Whether SSL certificate of any data node has expired (If Hadoop cluster is SSL enabled).   c) If the SSL changes were made and services that are using the SSL is not restarted after the activity the issue will occur, need to restart the services in the cluster which are using the SSL. ... View more

Thank you Vidya ... View more

Hi   below are some pointers just in case not tried  ( which I believe you using them ) set the column value to TIMESTAMP --  ( map-column-hive <cols_name>=TIMESTAMP)  Then please keep in mind the column should be bigint The main issue is the format. Parquet represent time in "msec" where as impala will interpret BigInt as "sec" so to get correct value you need to take care at query level. ( divide by 1000)    Regards Jay   ... View more

Hello Everyone,   As far as I know, Hive does not support async SQL call to the hive server. Every query session should wait until the queries are executed and then only the result can be captured. If we use the multithreaded query execution using java thread then only first few queries will be accepted by the YARN Job depends on the resource availability.    Correct me if someone has a better idea to deal with such a scenario.   Waiting for others response.    Regards, Dhirendra Pandit ... View more

@Girish1980:   Please follow the below steps :   1. Create the file with timestamp : >  touch timestamp_`date +"%s"` 2. upload the file in hdfs location. > hdfs dfs -put timestamp_1615114389 /data 3. To save the latest fsimage add the namenode in safemode > hdfs dfsadmin -safemode enter 4. save the latest fsimage > hdfs dfsadmin -saveNamespace 5. After saving the latest fsimage safemode disable >hdfs dfsadmin -safemode leave 6. download the latest fsimage to local system directory >hdfs dfsadmin –fetchImage /data 7. Read the fsimage file to check timestamp_file by converting into xml file > hdfs oiv -p XML -i fsimage_0000000000000055633 -o fsimage.xml  ... View more

Please mark and give us kudos so it encourages the fellow users to contribute more ! ... View more

Hi,   I got the same error in hue 3.1.0. The sql works fine with beeline but will get same error with hue. And we're also using impala hive HA.   Tried [Set use_get_log_api=true in the beeswax section ], and it's not working. Do you have any other solution? ... View more

I add manually kafka account and grant root privilege to kafka account, but it doesn't still work.     ... View more

The titled  SocketTimeoutException occurs when the thrift-client in hiveConnection object is in the process of actively reading sql results from  hive server2 ( thrift server), and is not able to receive anything until the TSocket's time out occurs.  You can check the source code from:HiveConnection.setupLoginTimeout and HiveAuthFactory.getSocketTransport. So you need to either tuning hiveserver2, or increase the TSocket's timeout setting. And for now, the only way to increase Tsocket's time out setting is via: DriverManager.setLoginTimeout()   you can check below jira for more information: https://issues.apache.org/jira/browse/HIVE-22196 https://issues.apache.org/jira/browse/HIVE-6679 https://issues.apache.org/jira/browse/HIVE-12371 ... View more

Is ther any solution for this issue. I am facing same issue. Table is holding very huge data and while doing insert overwrite , files are getting placed in my user directory, /user/anjali/.Trash, causing hive action in oozie to fail after 1.5 hr long run. Please help. The table is external and ev even I changed it to internal table, auto purge = true is not working. ... View more

[quickstart.cloudera:21000] > history; [1]: help; [2]: version; [3]: history; [4]: exit; [5]: profile; [6]: help; [7]: profile; [8]: history; [9]: version; [10]: profile; [11]: CREATE DATABASE IF NOT EXISTS my_database; [12]: history; [quickstart.cloudera:21000] > sudo service impala-state-store start; Query: sudo service impala-state-store start Query submitted at: 2020-02-02 22:11:26 (Coordinator: http://quickstart.cloudera:25000) ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore. [quickstart.cloudera:21000] > sudo service impala-catalog start > [quickstart.cloudera:21000] > sudo service impala-catalog start; Query: sudo service impala-catalog start Query submitted at: 2020-02-02 22:11:48 (Coordinator: http://quickstart.cloudera:25000) ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore. Hi , I'm getting an error when fire both the below commands. kindly help  sudo service impala-state-store start; sudo service impala-catalog start; ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from the StateStore. ... View more

Could you try performing the "Validate hivemetastore schema "  from Cloudera manager - > Hive service then  Let us know if you are able to create the same table. ... View more

Hi can you help me out how to write a shell script to backup fsimage. ... View more

Hey,   CSD Version: 2.3 & higher, I think.   Regards, Ankit. ... View more

I had exactly the same issue and turned out that the count includes also snapshot. To check if that's the case one can add -x option in the count, e.g.:   hdfs dfs -count -v -h -x   /user/hive/warehouse/my_schema.db/* ... View more

This is really a nice article. Kudos to you.  ... View more