You will need to update the VIEW: ALTER VIEW v1 AS SELECT * FROM t1; The columns for the VIEW is stored separately as the table's columns, updating the table will not affect the VIEW. You will need to manually update it. ... View more

Glad that issue is now resolved! ... View more

This will not work. set hivevar:tab_dt= substr(date_sub(current_date,1),1,10); Only sets variable hivevar:tab_dt to be string "substr(date_sub(current_date,1),1,10)", not the value as the result of evaluation of the function call. You will need get the date string outside of Hive and then pass in as the variable. So below will work: set hivevar:tab_dt=2017_10_01; create table test_${hivevar:tab_dt} (a int); ... View more

You can create hive external table to link to the data in HDFS, and then write data into another table which will be partitioned by date. Use date functions in Hive to convert timestamp to the value you want: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions INSERT OVERWRITE TABLE partitioned_table PARTITION (date_column) SELECT ...., to_date(timestamp_column) as date_column FROM source_table; Something like this. ... View more

Can you also share the ClouderaODBCDriverforImpala_connection_0.log file? If PROFILE and log files are too big, are you able to share through Dropbox or other online tools? They should help us understand more on the issue. ... View more

Are you able to share the full PROFILE output of the query for review? That queries through OBDC driver? ... View more

You can enable TRACE logging for ODBC driver via "Logging Options" menu, and then you can see what happened on the client side. Please also check on HS2 log to see what message displays there. ... View more

The following link: http://gethue.com/use-the-shell-action-in-oozie/ from Hue website is about how to setup script shell in Hue Oozie interface. Python script will be similar. I suggest you go through the documentation on Hue for more detailed info. ... View more

Can you please share the content of shexample7.sh? I would like to see how you launch the spark job in shell script. ... View more

Hi Ullas, Can you please share the DDL of the table from both Impala and Hive and also the ALTER command you used to update schema? Thanks ... View more