Hive count(*) anormal result--> it returns just last number of inserted records

Hi geeks, I have a table ( myTable in orc format), when I insert in this table records : ( insert into table myTable select * from another_table -- in the folder where data are sotred I find files: 0_0 (first insert), 0_0, 0_1 (second insert), ...etc-- ) and when I do : select coun

Re: Enabling Tez sessions on HiveServer2

Yes i am using HiveServer2, but we haven't enabled SqlStdAuth yet. Are you saying with SqlStdAuth enabled, impersonation with doAs is not required because Hive will do the right thing with table ownership, auditing etc, i.e. run the command as the logged on user? On Thu, Dec 4, 2014 at 6:32 PM, Go

Re: Hive 0.14 SQL Inserts Complex Data Types

There are UDFs to create complex types, would something like this work? INSERT .. VALUES select map('key1', 'val1', 'key2', 'val2'); On Dec 19, 2014, at 8:50 AM, Skyler Beckman wrote: > Thanks > > From: Alan Gates [mailto:ga...@hortonworks.com] > Sent: Friday, December 19, 2014 11:35 AM

RE: Hive 0.14 SQL Inserts Complex Data Types

Thanks From: Alan Gates [mailto:ga...@hortonworks.com] Sent: Friday, December 19, 2014 11:35 AM To: user@hive.apache.org Subject: Re: Hive 0.14 SQL Inserts Complex Data Types Hive does not support literals for complex types, so it is not possible to use them in INSERT...VALUES clauses. Alan.

Re: Hive 0.14 SQL Inserts Complex Data Types

Hive does not support literals for complex types, so it is not possible to use them in INSERT...VALUES clauses. Alan. Skyler Beckman December 17, 2014 at 9:59 With 0.14 is it possible to use the INSERT…VALUES statement to insert data into a table with compl

Window Function with Ignore Nulls?

Hi, I'm currently on Hive 0.11. I'm trying to pull the last non-null record from a dataset. Ideally, I would use something like this: Select id, last_value(address ignore nulls) over (partition by id order by file_date) as address from address_table; But Hive d

Re: How to pass information to hive udf except as arguments

As per this url, How can I fetch these variables in hive udf. On 19 December 2014 at 14:30, Daniel Haviv wrote: > > First result in google: > > http://stackoverflow.com/questions/12464636/how-to-set-variables-in-hive-scripts > > Daniel > > On 19 בדצמ׳ 2014, at 10:54, Dilip Agarwal > wrote: > > >

Re: How to pass information to hive udf except as arguments

First result in google: http://stackoverflow.com/questions/12464636/how-to-set-variables-in-hive-scripts Daniel > On 19 בדצמ׳ 2014, at 10:54, Dilip Agarwal wrote: > > > Hi, I have created a udf which accepts geo location points as arguments and > return the name of location fetching from a ur

How to pass information to hive udf except as arguments

Hi, I have created a udf which accepts geo location points as arguments and return the name of location fetching from a url. I have to set this URL dynamically at the time of hive script run. I don't like to pass this url as separate argument tot the udf evaluate method. Is there a way to set this