Created 11-04-2016 09:47 AM
HDP-2.5.0.0 using Ambari 2.4.0.1
I was trying to execute a Hive query like :
SELECT DISTINCT ...... ,ROW_NUMBER() OVER(PARTITION BY .....)
when I got the error :
Error: Error while compiling statement: FAILED: SemanticException SELECT DISTINCT not allowed in the presence of windowing functions when CBO is off (state=42000,code=40000)
I ended up in this Apache Hive JIRA case. I have the following questions :
Created 11-13-2016 09:58 PM
Applying patches is technically possible though not supported by HWX. you will have to fetch the right build of Hive, compile, deploy and update symlinks. HDP 2.5.x is right around the corner, cross your fingers that the said patch is included. I'd love to confirm it but latest release notes have not been published.
Created 11-13-2016 09:58 PM
Applying patches is technically possible though not supported by HWX. you will have to fetch the right build of Hive, compile, deploy and update symlinks. HDP 2.5.x is right around the corner, cross your fingers that the said patch is included. I'd love to confirm it but latest release notes have not been published.