timestamps

[gpogliani]

Trying to connect an oracle table with timestamps but i get a cast error. How can i fix it? Thanks SQL Error: java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date SQL Error: java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date SQL Error: java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date SQL Error: java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.sql.Date java.sql.Timestamp cannot be cast to java.sql.Date java.sql.Timestamp cannot be cast to java.sql.Date

[lampjian]

Oracle date type is the same as java.sql.Timestamp, so you can't convert this directly. You should change the type mapping rules.