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.

Getting the following error while running sql on hive using odbc driver

Highlighted

Getting the following error while running sql on hive using odbc driver

Explorer

We are connecting to hive and running sql thru ODBC driver. Getting the following error

hortonworks error [Hortonworks][SQLEngine] (31340) DATEDIFF is not a valid scalar function or procedure call. we have a sql which has a select and it has a simple datediff which seems to be causing the issue

DATEDIFF('2017-02-02', '2017-02-01') as Exp_curr_dt

Have any of you experienced this issue? please let me know if you have any suggestions to fix this.

Also, the parent query has an alias which has an underscore in the front of the name and it doesn't work if I directly execute this unless I enclose it within tick symbol. But from odbc however the query goes thru except for the datediff part.

We are using the 2.1.5 odbc driver 64 bit version. The application connecting to hive and executing sql is written in .net

Thanks

3 REPLIES 3
Highlighted

Re: Getting the following error while running sql on hive using odbc driver

@Anika S

I didn't see any issue with datediff function through hdp 2.1.5 ODBC driver.

12042-datediff.png

Highlighted

Re: Getting the following error while running sql on hive using odbc driver

Explorer

Thank you.

Highlighted

Re: Getting the following error while running sql on hive using odbc driver

Expert Contributor

@Anika S 2 years later, I have the same issue. Did you manage to fix it? If so, how?

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