Hi, Below is the solution. I have checked in hdfs level for the date format and have given the same order in "formats" value as below.   My Date Format : 2019-02-02   Alter Command : ALTER TABLE <TN> SET SERDEPROPERTIES ("timestamp.formats"="yyyy-mm-dd'");   Thanks ... View more

@Harsh J How  would I do this   just for   one job ?.   I tried using  below  setting but it is not working. The issue is that I want to  use a version of jersey which I bundled into my fat jar,however  gateway node  has an older version of  that jar and it loads a class from  there resulting in a NosSuchMethodException .My application is not a map reduce job and I run it by using  hadoop jar and running on 5.14.4   export HADOOP_USER_CLASSPATH_FIRST=true export HADOOP_CLASSPATH=/projects/poc/test/config:$HADOOP_CLASSPATH ... View more

SELECT DAYS_SUB(NOW(), DAYOFWEEK(NOW()) +1) AS last_friday; Thats  what i needed. Thank you!! ... View more

ah  i see. That makes sense now. Thank you ... View more

It seems that only db_name is needed according to  https://www.cloudera.com/documentation/enterprise/5-15-x/topics/impala_refresh_functions.html Syntax: REFRESH FUNCTIONS db_name   And in 2.X version of impala the only way is to grant all on server to the role, while in  Impala 3.0 and higher  the minimum level of privileges required by refresh functions is to grant refresh on database to the role. SQL Statement Privileges Scope REFRESH FUNCTIONS REFRESH DATABASE https://impala.apache.org/docs/build/html/topics/impala_grant.html ... View more

Thank you for your quick reply.   In the Kerberized environment, when LB was set for HS2 and Impalad, I understood that I can connect directly to HS2, but I can not connect directly to Impalad.   Thank you for responding to DOC correction. Because I often refer to DOC, I help a lot. ... View more

Thanks EricL !!! ... View more

Metainfo "partitions" mast have information about rules for partition (what column, size of part), not "partition instances". The same about index - need info about tuple of columns included into index. ... View more

My CDH cluster version is cdh6.0.1. services is kafka, hdfs, hive, impala, hue.   I tested it in the following order. 1. set idele timeout value    cloudera manager > impala > snippet(safe value)    -idle_query_timeout=30    -idle_session_timeout=120 2. check timeout value.    cloudera manager > impala > instance > impala daemon web ui > http://[impalad host]:25000/varz    idle_session_timeout value setted 120 3. monitoring server's tcp connections    ssh connect to impalad host    $ watch -n 1 -d 'netstat -anpt | grep 21050' 4. java client application jdbc    Connection connection = DriverManager.getconnection("jdbc:impala://....");    Statement statement = connection.createStament();    System.exit(0); 5. impalad server. establishe tcp connection    The connection will not be terminated after multi minutes. 6. check impala daemon web ui    can see tcp connection in web ui.    impala daemon web ui > http://[impalad host]:25000/sessions do action 'close' However, the tcp connection is still established. ... View more