Reply
Explorer
Posts: 31
Registered: ‎08-29-2017

SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK

select from_unixtime(unix_timestamp('161223000001', 'yyMMddHHmmss'))

2016-12-23 00:00:01

when i try to insert value

insert into table tblename values (from_unixtime(unix_timestamp('161223000001', 'yyMMddHHmmss')),'s2a','uem',10.6,'hj')

Error while compiling statement: FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values

I want to convert the int into timestamp during insertion.

Doubt 2:

suppose if i have a value 1506614501 to be converted to timestamp?

Announcements