search

lucidworks / hive-solr

Code to index Hive tables to Solr and Solr indexes to Hive
Apache License 2.0
47 stars 34 forks source link

Cannot query timestamp type after indexed #33

Open scoaste opened 7 years ago

scoaste commented 7 years ago

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)?

AttilaZz commented 6 years ago

@scoaste did found any solution for this ?