Fwd: passing Xml using hive

2014-01-09 Thread Ranjini Rathinam
Hi, This is my xml file 100 ranjini IT1 123456 nextlevel1 Chennai1 Navallur1 1001 ranjinikumar IT 1234516 nextlevel Chennai Navallur In hive shell , i use xpath hive> select xpath(str,'/Company/Employee/ename/text()') from hivexml; Total MapReduce jobs = 1 Launching Job 1 out of 1

RE: Vectorizied execution on RCFile

2014-01-09 Thread Eric Hanson (BIG DATA)
There’s actually a different inputformat for vectorized processing on RCFile. See https://issues.apache.org/jira/browse/HIVE-4483. Vectorized execution won’t run as fast on RCFile as ORC, but there should still be a noticeable improvement on RCFile. In the future, I think it’s best to update th

Re: [DISCUSS] Proposed Changes to the Apache Hive Project Bylaws

2014-01-09 Thread Lefty Leverenz
> ... to nudge committers to review patches sooner ... I'm of two minds about this, so I'd like to hear more opinions. In theory, picking up the pace seems like a good idea. But in practice, everybody has other tasks to juggle so reviewing patches doesn't always find a place in the daily schedu

Re: Pointing multiple external tables to the same location

2014-01-09 Thread Petter von Dolwitz (Hem)
Hi Navis (and others), seems like my solution with views does not work after all. That is, it works fine as long as I do not use filter pushdown. My setup is something like below: CREATE EXTERNAL TABLE MasterTable ( column1 STRING, column2 STRING, column3 STRING column4 STRING) PARTITIO