Hi @kerjo, Did you fixed the map-column hive ignored issue? Could you please share your ideas? It would be very helpful Regards, Ganeshbabu R ... View more

@Artem Ervits I will do the changes in our sqoop lib folder and will post my response back to you 🙂 ... View more

Hi @Artem Ervits Yes I could see the java class changes related the date field (F_INI_APPEARANCE_DATE) and below is the code generated in the class file, Let me know your thoughts on this.. But why type is not showing in the .metadata file, attached the sample image, sample code:- private java.sql.Timestamp F_INI_APPEARANCE_DATE; public java.sql.Timestamp get_F_INI_APPEARANCE_DATE() { return F_INI_APPEARANCE_DATE; } public void set_F_INI_APPEARANCE_DATE(java.sql.Timestamp F_INI_APPEARANCE_DATE) { this.F_INI_APPEARANCE_DATE = F_INI_APPEARANCE_DATE; } public QueryResult with_F_INI_APPEARANCE_DATE(java.sql.Timestamp F_INI_APPEARANCE_DATE) { this.F_INI_APPEARANCE_DATE = F_INI_APPEARANCE_DATE; return this; } ... View more

@Artem Ervits I removed those double quotes and tried again with the same sqoop command but still gettting the same datatype was not changed. we are using Hive version is 1.1.0 I checked the java class code in the sqoop execution path but couldn't see any changes related to that command and below is the warning logs showed during sqoop, Warning: /opt/cloudera/parcels/CDH-5.5.2-1.cdh5.5.2.p0.4/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 17/02/20 10:58:44 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.5.2 17/02/20 10:58:44 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 17/02/20 10:58:44 WARN tool.BaseSqoopTool: It seems that you've specified at least one of following: 17/02/20 10:58:44 WARN tool.BaseSqoopTool: --hive-home 17/02/20 10:58:44 WARN tool.BaseSqoopTool: --hive-overwrite 17/02/20 10:58:44 WARN tool.BaseSqoopTool: --create-hive-table 17/02/20 10:58:44 WARN tool.BaseSqoopTool: --hive-table 17/02/20 10:58:44 WARN tool.BaseSqoopTool: --hive-partition-key 17/02/20 10:58:44 WARN tool.BaseSqoopTool: --hive-partition-value 17/02/20 10:58:44 WARN tool.BaseSqoopTool: --map-column-hive 17/02/20 10:58:44 WARN tool.BaseSqoopTool: Without specifying parameter --hive-import. Please note that 17/02/20 10:58:44 WARN tool.BaseSqoopTool: those arguments will not be used in this session. Either 17/02/20 10:58:44 WARN tool.BaseSqoopTool: specify --hive-import to apply them correctly or remove them 17/02/20 10:58:44 WARN tool.BaseSqoopTool: from command line to remove this warning. 17/02/20 10:58:44 INFO tool.BaseSqoopTool: Please note that --hive-home, --hive-partition-key, 17/02/20 10:58:44 INFO tool.BaseSqoopTool: hive-partition-value and --map-column-hive options are 17/02/20 10:58:44 INFO tool.BaseSqoopTool: are also valid for HCatalog imports and exports 17/02/20 10:58:44 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled. 17/02/20 10:58:44 INFO manager.SqlManager: Using default fetchSize of 1000 17/02/20 10:58:44 INFO tool.CodeGenTool: Beginning code generation Not sure we need to include we need to add those parameter.. ... View more