Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SemanticException [Error 10293]:

Solved Go to solution
Highlighted

SemanticException [Error 10293]:

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: SemanticException [Error 10293]:

@Gayathri Devi,

Can you try this query

insert into table tblename select * from (select from_unixtime(unix_timestamp('161223000001', 'yyMMddHHmmss')))b;

#2) If you have timestamp as '1506614501'

hive> select from_unixtime(unix_timestamp('1506614501', 'yyMMddHHmm'));
OK
2015-08-01 21:01:00
Time taken: 0.257 seconds, Fetched: 1 row(s)

Thanks,

Aditya

1 REPLY 1

Re: SemanticException [Error 10293]:

@Gayathri Devi,

Can you try this query

insert into table tblename select * from (select from_unixtime(unix_timestamp('161223000001', 'yyMMddHHmmss')))b;

#2) If you have timestamp as '1506614501'

hive> select from_unixtime(unix_timestamp('1506614501', 'yyMMddHHmm'));
OK
2015-08-01 21:01:00
Time taken: 0.257 seconds, Fetched: 1 row(s)

Thanks,

Aditya

Don't have an account?
Coming from Hortonworks? Activate your account here