How did you resolve the issue? I am facing a similar problem with datanode not starting   ... 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

@Venkat_ 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

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

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

Could you run the administrator cmd not a normal one? From your error, I think you have not enough privilege to run these commands. ... View more