0

I am trying to run some hive functinos in Dbeaver tool but it always giving the below error

What I am trying to run is for example :

SELECT from_unixtime(unix_timestamp('17-Sep-21', 'dd-MMM-yy'),'dd-MMM-yy');

error I am getting :

SQL Error [30328] [50000]: TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException

TEIID30328 Unable to evaluate timestampadd(SQL_TSI_SECOND, unix_timestamp('17-Sep-21', 'dd-MMM-yy'), {ts'1969-12-31 19:00:00.0'})

TEIID30341 Function impala.unix_timestamp is marked in the function metadata as a function that must be evaluated at the source.

Ergest Basha
  • 7,870
  • 4
  • 8
  • 28
Ganesh galla
  • 15
  • 1
  • 4

1 Answers1

0

The full stack trace should contain more information as to why it can't evaluate. Most of the later versions of Teiid even for pushdown functions will pre-evaluate them if the surrounding expression cannot be pushed.

Steven Hawkins
  • 538
  • 1
  • 4
  • 7