hive-solr icon indicating copy to clipboard operation
hive-solr copied to clipboard

Cannot query timestamp type after indexed

Open scoaste opened this issue 7 years ago • 1 comments

Source hive table has columns of type timestamp. I mapped this to hive-solr column type of timestamp and schema field type tdate (which has precision 6). Upon querying, received error:

Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Timestamp

Value is stored as TrieDateField with correct precision. Shouldn't the SerDe treat this as a timestamp (and precision 0 as a date)?

scoaste avatar Jul 10 '17 21:07 scoaste

@scoaste did found any solution for this ?

AttilaZz avatar May 03 '18 15:05 AttilaZz