[jira] Updated: (HIVE-1430) serializing/deserializing the query plan is useless and expensive

2010-06-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1430: - Status: Resolved (was: Patch Available) Hadoop Flags: [Reviewed] Fix Version/s: 0.7.0

[jira] Updated: (HIVE-187) ODBC driver

2010-06-23 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-187: Attachment: thrift_64.r790732.tgz Uploading thrift_64.r790732.tgz the complete 64 bit thrift libs (including

[jira] Updated: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1176: - Status: Resolved (was: Patch Available) Hadoop Flags: [Reviewed] Fix Version/s: 0.7.0

[jira] Commented: (HIVE-1271) Case sensitiveness of type information specified when using custom reducer causes type mismatch

2010-06-23 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12882048#action_12882048 ] Arvind Prabhakar commented on HIVE-1271: @Ashish: I created HIVE-1432 to track the t

[jira] Created: (HIVE-1432) Create a test case for case sensitive comparison done during field comparison

2010-06-23 Thread Arvind Prabhakar (JIRA)
Create a test case for case sensitive comparison done during field comparison - Key: HIVE-1432 URL: https://issues.apache.org/jira/browse/HIVE-1432 Project: Hadoop Hive

[jira] Commented: (HIVE-1431) Hive CLI can't handle query files that begin with comments

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12882028#action_12882028 ] John Sichi commented on HIVE-1431: -- sqlline (see my notes in HIVE-987) deals with comments

Re: 6.0 and trunk look broken to me

2010-06-23 Thread Edward Capriolo
On Wed, Jun 23, 2010 at 10:48 PM, John Sichi wrote: > Did you get past this?  It looks like some kind of bad build. > > JVS > > On Jun 23, 2010, at 2:38 PM, Ashish Thusoo wrote: > >> Not sure if this is just my env but on 0.6.0 when I run the unit tests I get >> a bunch of errors of the following

[jira] Commented: (HIVE-1431) Hive CLI can't handle query files that begin with comments

2010-06-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12882024#action_12882024 ] Edward Capriolo commented on HIVE-1431: --- We have a few tickets open, we really need to

[jira] Updated: (HIVE-1342) Predicate push down get error result when sub-queries have the same alias name

2010-06-23 Thread Ted Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Xu updated HIVE-1342: - Status: Patch Available (was: Open) Affects Version/s: 0.6.0 (was: 0.5.0

Review Request: Hive Variables

2010-06-23 Thread Edward Capriolo
--- This is an automatically generated e-mail. To reply, visit: http://review.hbase.org/r/229/ --- Review request for Hive Developers. Summary --- Hive Variables Diffs -

[jira] Updated: (HIVE-1096) Hive Variables

2010-06-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo updated HIVE-1096: -- Attachment: hive-1096-11-patch.txt Was not interpolating system:vars. Fixed with better test cas

Re: 6.0 and trunk look broken to me

2010-06-23 Thread John Sichi
Did you get past this? It looks like some kind of bad build. JVS On Jun 23, 2010, at 2:38 PM, Ashish Thusoo wrote: > Not sure if this is just my env but on 0.6.0 when I run the unit tests I get > a bunch of errors of the following form: > >[junit] Begin query: alter3.q >[junit] java.l

[jira] Commented: (HIVE-1271) Case sensitiveness of type information specified when using custom reducer causes type mismatch

2010-06-23 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881998#action_12881998 ] Ashish Thusoo commented on HIVE-1271: - I have committed this to trunk and will commit to

[jira] Commented: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881967#action_12881967 ] John Sichi commented on HIVE-1176: -- +1. Will commit when tests pass. > 'create if not ex

[jira] Updated: (HIVE-1307) More generic and efficient merge method

2010-06-23 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1307: - Attachment: HIVE-1307.0.patch Uploading a preliminary patch. This is not ready for review yet. > More ge

[jira] Updated: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Arvind Prabhakar updated HIVE-1176: --- Attachment: HIVE-1176-6.patch > 'create if not exists' fails for a table name with 'select' in

[jira] Commented: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881956#action_12881956 ] Arvind Prabhakar commented on HIVE-1176: yes - thats what my intention was. Thanks f

[jira] Updated: (HIVE-1096) Hive Variables

2010-06-23 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1096: - Fix Version/s: (was: 0.5.1) Affects Version/s: (was: 0.5.0) > Hive Variables > ---

[jira] Updated: (HIVE-1387) Make PERCENTILE work with double data type

2010-06-23 Thread Mayank Lahiri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mayank Lahiri updated HIVE-1387: Attachment: HIVE-1387.2.patch median_approx_quality.png I've attached HIVE-1387.2.pa

[jira] Updated: (HIVE-1096) Hive Variables

2010-06-23 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1096: - Fix Version/s: 0.5.1 0.7.0 > Hive Variables > -- > >

[jira] Updated: (HIVE-1387) Make PERCENTILE work with double data type

2010-06-23 Thread Mayank Lahiri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mayank Lahiri updated HIVE-1387: Status: Patch Available (was: Open) Affects Version/s: 0.6.0 Fix Version/s: 0

[jira] Commented: (HIVE-1096) Hive Variables

2010-06-23 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881955#action_12881955 ] Carl Steinbach commented on HIVE-1096: -- Hi Ed, can you please post this patch to review

[jira] Commented: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881950#action_12881950 ] John Sichi commented on HIVE-1176: -- Thanks for the doc Arvind. But for the patch: we ne

[jira] Commented: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881946#action_12881946 ] Arvind Prabhakar commented on HIVE-1176: @John: done. Please see the new patch attac

[jira] Updated: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread Arvind Prabhakar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Arvind Prabhakar updated HIVE-1176: --- Attachment: HIVE-1176-5.patch > 'create if not exists' fails for a table name with 'select' in

[jira] Created: (HIVE-1431) Hive CLI can't handle query files that begin with comments

2010-06-23 Thread Carl Steinbach (JIRA)
Hive CLI can't handle query files that begin with comments -- Key: HIVE-1431 URL: https://issues.apache.org/jira/browse/HIVE-1431 Project: Hadoop Hive Issue Type: Bug Componen

[jira] Commented: (HIVE-1430) serializing/deserializing the query plan is useless and expensive

2010-06-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881942#action_12881942 ] Namit Jain commented on HIVE-1430: -- +1 > serializing/deserializing the query plan is usele

[jira] Commented: (HIVE-1176) 'create if not exists' fails for a table name with 'select' in it

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881936#action_12881936 ] John Sichi commented on HIVE-1176: -- Just one more change needed...please add an ORDER BY to

[jira] Updated: (HIVE-1430) serializing/deserializing the query plan is useless and expensive

2010-06-23 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1430: - Status: Patch Available (was: Open) > serializing/deserializing the query plan is useless and expensive >

[jira] Updated: (HIVE-1430) serializing/deserializing the query plan is useless and expensive

2010-06-23 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1430: - Attachment: HIVE-1430.patch > serializing/deserializing the query plan is useless and expensive >

[jira] Created: (HIVE-1430) serializing/deserializing the query plan is useless and expensive

2010-06-23 Thread Namit Jain (JIRA)
serializing/deserializing the query plan is useless and expensive - Key: HIVE-1430 URL: https://issues.apache.org/jira/browse/HIVE-1430 Project: Hadoop Hive Issue Type: Bug

[jira] Commented: (HIVE-1416) Dynamic partition inserts left empty files uncleaned in hadoop 0.17 local mode

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881921#action_12881921 ] John Sichi commented on HIVE-1416: -- Attached junit-noframes.html with the failures (but not

[jira] Updated: (HIVE-1416) Dynamic partition inserts left empty files uncleaned in hadoop 0.17 local mode

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1416: - Attachment: junit-noframes.html > Dynamic partition inserts left empty files uncleaned in hadoop 0.17 loca

[jira] Updated: (HIVE-1416) Dynamic partition inserts left empty files uncleaned in hadoop 0.17 local mode

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1416: - Status: Open (was: Patch Available) Ning, this ran through cleanly with Hadoop 0.17 (where I verified tha

RE: 6.0 and trunk look broken to me

2010-06-23 Thread Ashish Thusoo
Not sure if this is just my env but on 0.6.0 when I run the unit tests I get a bunch of errors of the following form: [junit] Begin query: alter3.q [junit] java.lang.NoSuchFieldError: HIVESESSIONSILENT [junit] at org.apache.hadoop.hive.ql.exec.ExecDriver.main(ExecDriver.java:1052

[jira] Updated: (HIVE-1229) replace dependencies on HBase deprecated API

2010-06-23 Thread Basab Maulik (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Basab Maulik updated HIVE-1229: --- Attachment: HIVE-1229.2.patch fixed checkstyle violations and rebased against trunk. Tests run succes

Re: 6.0 and trunk look broken to me

2010-06-23 Thread John Sichi
(You mean 0.6, right?) I'm not able to reproduce this (just tested with latest trunk on Linux and Mac). Is anyone else seeing it? JVS On Jun 23, 2010, at 1:51 PM, Edward Capriolo wrote: > Trunk and 6.0 both show this in hadoop local mode and hadoop distributed mode. > > export HADOOP_HOME=/h

[jira] Resolved: (HIVE-56) The reducer output is not created if the mapper input is empty

2010-06-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-56?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain resolved HIVE-56. Fix Version/s: 0.6.0 Resolution: Fixed This was fixed a long time back. In hive, an empty input is crea

[jira] Updated: (HIVE-1229) replace dependencies on HBase deprecated API

2010-06-23 Thread Basab Maulik (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Basab Maulik updated HIVE-1229: --- Attachment: (was: HIVE-1129.1.patch) > replace dependencies on HBase deprecated API >

6.0 and trunk look broken to me

2010-06-23 Thread Edward Capriolo
Trunk and 6.0 both show this in hadoop local mode and hadoop distributed mode. export HADOOP_HOME=/home/edward/hadoop/hadoop-0.20.2_loca edw...@ec dist]$ export HADOOP_HOME=/home/edward/hadoop/hadoop-0.20.2_local[edw...@ec dist]$ bin/hive Hive history file=/tmp/edward/hive_job_log_edward_201006231

[jira] Updated: (HIVE-1359) Unit test should be shim-aware

2010-06-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1359: - Status: Resolved (was: Patch Available) Hadoop Flags: [Reviewed] Resolution: Fixed Commit

Re: problem with hive to integrate with hbase

2010-06-23 Thread John Sichi
Hi Muhammad, Just build from the top level of hive trunk (not from the hbase-handler component) and everything, including the hbase-handler, will be built for you. Follow the normal Hive build instructions in http://wiki.apache.org/hadoop/Hive/HowToContribute Note that we currently build agai

[jira] Commented: (HIVE-1271) Case sensitiveness of type information specified when using custom reducer causes type mismatch

2010-06-23 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881767#action_12881767 ] Ashish Thusoo commented on HIVE-1271: - sounds good to me. Thanks for the explanations.

[jira] Commented: (HIVE-1018) pushing down group-by before joins

2010-06-23 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881758#action_12881758 ] Ning Zhang commented on HIVE-1018: -- Good points Joy. It will be interesting to see what are

[jira] Updated: (HIVE-1096) Hive Variables

2010-06-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo updated HIVE-1096: -- Status: Patch Available (was: Open) > Hive Variables > -- > > Key:

[jira] Updated: (HIVE-1096) Hive Variables

2010-06-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo updated HIVE-1096: -- Attachment: hive-1096-10-patch.txt Patch adds variable interpretation. > Hive Variables >

problem with hive to integrate with hbase

2010-06-23 Thread Muhammad Mudassar
Hi all I want to integrate hive with hbase. I am running single node Hbase 0.20.2 with hadoop 0.20.2 configured in single node cluster mode. when I tried to run *ant jar* from Hbase-Handler to get hive_hbase_handler.jar it gives me errors like: setup: compile: [echo] Compiling: hbase-handler

Re: real time query option

2010-06-23 Thread Edward Capriolo
On Wed, Jun 23, 2010 at 2:12 AM, Amr Awadallah wrote: > For low-latency queries you should either use HBase instead, or consider > Hive over HBase, see: > > http://www.cloudera.com/blog/2010/06/integrating-hive-and-hbase/ > > -- amr > > On 6/22/2010 11:05 PM, jaydeep vishwakarma wrote: >> >> Hi, >

[jira] Commented: (HIVE-1018) pushing down group-by before joins

2010-06-23 Thread Joydeep Sen Sarma (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881597#action_12881597 ] Joydeep Sen Sarma commented on HIVE-1018: - interesting idea. in most of the queries

[jira] Updated: (HIVE-1304) add row_sequence UDF

2010-06-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1304: - Status: Resolved (was: Patch Available) Hadoop Flags: [Reviewed] Resolution: Fixed Commit