tablesample query on bucketed ORC table needs execute access in Hive 0.13

In Hive 0.13 when I do a tablesample query on an ORC table, such as select x from orc_table tablesample (bucket 32 out of 64) where date=1106; I'll get the following error saying I'm trying to run with EXECUTE access but the files have only READ access for non owner. Why would a simple select que

Hive and Hbase types

Hi Guys, I am trying to to map Hbase table to a Hive table ( an external table). I am using a hive create statement to create the hbase tables. That works, I was wondering how does HiveSQL types relate to Hbase types? I mean how does one go about translate Hbase long to Hive SQL type. I am pushi

RE: Analytic functions in Lead & Lag in Hive

Ravi, Lead and Lag functions are introduced only in hive 0.11 version. Please refer to the below link for more details. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics Thanks, Karthik From: Ravi Prasad [mailto:raviprasa...@gmail.com] Sent: Friday, November

error when using arrays of union types

Hi there, it seems that it’s not possible to create an array of union types (see below). Is there a workaround for this? Best regards Michael In hive-0.14: hive> SELECT ARRAY(CREATE_UNION(1, 1, 'a')); OK Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveExcepti

Analytic functions in Lead & Lag in Hive

Cany anyone suggest, how to use the Lead and lag function in Hive. I am using Hive* 0.10 version*. Is there any way to make it work in 0.10 version. I have used the below code in Oracle, But it is not working in Hive. I need to compare the difference between the previous record and currect record