It looks like your row is of this format:
2415022|OKJNECAA|1900-
01-02
02:00:21.0|0|1|1|1900|1|1|2|1|1900|1|1|Monday|1900Q1|N|N|Y|2415021|2415020|2414657|2414930|N|N|N|N|N|
Where your timestamp is in the third field; however, your table only has a
single column. Hive is reading y
Hi All,
I am looking for some help in using timestamp column and not sure why I am
getting this error:
Here are how I created the tables and how I am querying it
--hdfs dfs -mkdir /hive/tpcds/date_ts
create external table date_ts
(
d_datetimestamp
)
row format delimited fi
