Re: Hive indexing optimization

2015-06-27 Thread John Pullokkaran
"SELECT StartIp, EndIp, Country FROM ipv4geotable” should have been rewritten as a scan against index table. BitMap Indexes seems to support inequalities (<=, <, >=). Post the explain plan. On 6/26/15, 8:56 PM, "Gopal Vijayaraghavan" wrote: >Hi, > >Hive indexes won¹t really help you speed up t

Is hive binary only for hadoop 1.x ?

2015-06-27 Thread canan chen
I mean if I want to run on hadoop 2.x, do I must to build it from source with hadoop 2.x ?

Creating ORC File from Text format( CSV File)

2015-06-27 Thread vengatesh.babu
Dear Team, In Java, Please suggest me way to write ORC File from text file delimited by comma without using Hive. With Hive : To create ORC FIle From Text File 1. Load Text file in Hive Table. 2. Create ORCTable stored as orc select * from TextTable(CTAS). I need to create ORC File from Text Fil