@csgunaThank you for the reply!   I am using Parquet and you are right, it is not supported for UPDATE and DELETE operations. Only ORC is supported.   @syamsriI suggest the last post from csguna should be marked as the correct answer. ... View more

Hi @csguna,   I haven't found any solutions to the problem (tried Hive CLI and HUE query editor). I will try to do a workaround...   What do you mean by "prerequisites"?   Version: CDH 5.12.1 Hive 1.1   Thanks! ... View more

EDIT: I have successfuly imported Date column from Oracle into Hive by modifiyng my query:   select t.trans_id, to_char(t.trans_date_sysdate,'YYYYMMDD_HH24MiSS') trans_date_char trans_date_char from test_table_1 t where $CONDITIONS   ... View more

@UjjwalRana   What version of Hive did you install? Did you manage to solve the issue?   Thanks! ... View more

Hi kerjo,   I was facing the same issue with map-column-java and map-column-hive while importing date/timestamp column from Oracle RDBMS to Hive parquet table using Sqoop. My Hive column is of type string. Version CDH 5.12.1, Parquet 1.5.0.   A partial workaround I discovered is to convert the Date column to string using a free form query in Sqoop.   Input column in oracle (type Date):   '16.11.2017 09:44:11'   --query   select t.trans_id, to_char(t.trans_date_sysdate) trans_date_char from test_table_1 t where $CONDITIONS Result in Hive looks like this:   16-NOV-17       Unfortunately, this is not enough, I am still not able to import the HH:mm:SS part.       ... View more