Request for edit permission to hive wiki

Hi, Could anyone grant me the edit permission of hive wiki? My Confluence user name: lirui Thanks a lot! Cheers. Rui Li

Dynamic Partitioning- Partition_Naming

I need a table partitioned by country and then city . I created a table and INSERTed data from another table using dynamic partition. CREATE TABLE invoice_details_hive _partitioned(Invoice_Id double,Invoice_Date string,Invoice_Amount double,Paid_Date string)PARTITIONED BY(pay_country STRING,pay_l

UDTF "KryoException: unable create/find class" error in hive 0.13

I wrote a UDTF in hive 0.13, the function parse a column which is json string and return a table. The function compiles successfully by adding hive-exec-0.13.0.2.1.2.1-471.jar to classpath, however when the jar is added to hive and a function created using the jar then I try to run a query using th

Re: wiki edit access

Done. Sorry for delay. Ashutosh On Tue, Sep 2, 2014 at 11:59 AM, Sergey Shelukhin wrote: > Hi. > Can I get wiki edit access for Hive? Confluence username sershe > > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity > to which it is addressed and m

Re: Nested types in ORC

Hi ORC stores nested fields as separate columns. For example: The following table create table orc_nested (key string, nested struct, zip long) stored as orc; will be flattened and stored as separated columns like below key, nested, nested.k, nested.v, zip you can have a look at the structure of

Nested types in ORC

Hi all, I have few questions with regards to nested columns in Hive. > How does ORC internally stores the complex types such as a struct? Are the nested fields stored as separate columns or is the whole struct is serialized as one column? > Is predicate pushdown supported for queries which access

Indexes vs Partitions in hive

Hi All, How indexes in hive are different than partitions? both improves query performance as per my knowledge then in what way they differ? What are the situations I'll be using indexing or partitioning? Can i use them together? Kindly suggest Regards, Chhaya Vishwakarma _

Re: collect_set does not remove duplicate

It will be helpful if you paste some sample data to repro. I have used collect_set and it works as documented for me. Thanks, Viral On Sun, Sep 7, 2014 at 10:39 AM, Shushant Arora wrote: > While group by, if I do collect_set on some other column , documentation > says it will return Array of