-
Created hive table
create external table customer_13(id int , name string , mytime timestamp) row format delimited fields terminated by ‘,’
stored as parquet location ‘/user/pawansingh7633750/customer_12’; -
select statement on timestamp
hive (a_pankaj_db)> select mytime from customer_13;
SLF4J: Failed to load class “org.slf4j.impl.StaticLoggerBinder”.
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.UnsupportedOperationException: Cannot
inspect org.apache.hadoop.io.LongWritable
Time taken: 5.684 seconds
Please suggest how to extract timestamp from select query or what should be the datatype while creating hive table for timestamp