Prasad,
Isn't the fractional part of the TIMESTAMP type supposed to be optional, as
per the error message :
Failed with exception
java.io.IOException:java.lang.IllegalArgumentException: Timestamp format
must be -mm-dd hh:mm:ss[.f]
Shall we understand 9 digits for fractional part are
Dilip,
Looks like you are using the data from the original schema for this new
table that has single timestamp column. When I tried with just the
timestamp from your data, the query runs fine. I guess the original issue
you hit on the data that didn't have fraction part (1969-12-31 19:00:00, no
Dileep,
Can you use a more contemporary timestamp? Something after Jan 1, 1970
GMT, say Jan 1st, 2013?
Let us know what you see.
On Tue, Mar 5, 2013 at 2:56 PM, Dileep Kumar wrote:
> --hdfs dfs -mkdir /hive/tpcds/date_ts
>
> create external table date_ts
> (
> d_datetimest
--hdfs dfs -mkdir /hive/tpcds/date_ts
create external table date_ts
(
d_datetimestamp
)
row format delimited fields terminated by '|'
location '/hive/tpcds/date_ts';
[cloudera@localhost tmp-work]$ hive -e "select * from date_ts"
Logging initialized using configuration in
f
No.
Here are the errors:
Task with the most failures(4):
-
Task ID:
task_1361599885844_0013_m_00
URL:
http://localhost.localdomain:50030/taskdetails.jsp?jobid=job_1361599885844_0013&tipid=task_1361599885844_0013_m_00
-
Diagnostic Messages for this Task:
Error: java.lang.RuntimeE
Hi Dilip,
Are you able to run this query successfully?
select d_date_sk, d_date_id, d_date, d_month_seq, d_week_seq,
d_quarter_seq, d_dow, d_moy, d_dom, d_qoy, d_fy_year,
d_fy_quarter_seq, d_fy_week_seq, d_day_name, d_quarter_name,
d_holiday, d_weekend, d_following_holiday, d_first_dom, d_last_dom
