[jira] Commented: (HIVE-1852) Reduce unnecessary DFSClient.rename() calls

2010-12-21 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12973519#action_12973519 ] He Yongqiang commented on HIVE-1852: @Joy, the FsShell delete is there because FB's

[jira] Updated: (HIVE-1852) Reduce unnecessary DFSClient.rename() calls

2010-12-21 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1852: - Attachment: HIVE-1852.4.patch @joydeep, you are right. if there is no 'local' keyword there is no

[jira] Commented: (HIVE-1847) option of continue on error

2010-12-21 Thread Thiruvel Thirumoolan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12973652#action_12973652 ] Thiruvel Thirumoolan commented on HIVE-1847: hive.cli.errors.ignore? Its set to

facebook friends relationship data

2010-12-21 Thread xintao
Dear all, I read this webpage (http://www.facebook.com/notes/facebook-engineering/visualizing-friendships/469716398919). Does it mean we can get the Facebook friendship data from here? Any of your reply is highly replied. Best regards, Xintao

[jira] Updated: (HIVE-1852) Reduce unnecessary DFSClient.rename() calls

2010-12-21 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1852: - Attachment: HIVE-1852.5.patch Uploading HIVE-1852.5.patch containing a simple log fix in

[jira] Commented: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

2010-12-21 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12973809#action_12973809 ] John Sichi commented on HIVE-1856: -- +1. Will commit when tests pass. Note for next time:

Build failed in Hudson: Hive-trunk-h0.20 #449

2010-12-21 Thread Apache Hudson Server
See https://hudson.apache.org/hudson/job/Hive-trunk-h0.20/449/changes Changes: [pauly] HIVE-1857 mixed case tablename on lefthand side of LATERAL VIEW results in query failing with confusing error message (John Sichi via pauly) [namit] HIVE-1855 Include Process ID in the log4j log file name

[jira] Commented: (HIVE-1853) downgrade JDO version

2010-12-21 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12973847#action_12973847 ] Namit Jain commented on HIVE-1853: -- Unfortunately, the query that I was running used some

[jira] Commented: (HIVE-1852) Reduce unnecessary DFSClient.rename() calls

2010-12-21 Thread Joydeep Sen Sarma (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12973883#action_12973883 ] Joydeep Sen Sarma commented on HIVE-1852: - Hive..java:1564 - this should read

[jira] Updated: (HIVE-1806) The merge criteria on dynamic partitons should be per partiton

2010-12-21 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1806: - Attachment: HIVE-1806.2.patch Uploading a new patch that resolved the diff in bucketmapjoin2.q. I'm

[jira] Created: (HIVE-1859) Hive's tinyint datatype is not supported by the Hive JDBC driver

2010-12-21 Thread Guy le Mar (JIRA)
Hive's tinyint datatype is not supported by the Hive JDBC driver Key: HIVE-1859 URL: https://issues.apache.org/jira/browse/HIVE-1859 Project: Hive Issue Type: Bug

[jira] Created: (HIVE-1860) Hive's smallint datatype is not supported by the Hive JDBC driver

2010-12-21 Thread Guy le Mar (JIRA)
Hive's smallint datatype is not supported by the Hive JDBC driver - Key: HIVE-1860 URL: https://issues.apache.org/jira/browse/HIVE-1860 Project: Hive Issue Type: Bug

[jira] Created: (HIVE-1861) Hive's float datatype is not supported by the Hive JDBC driver

2010-12-21 Thread Guy le Mar (JIRA)
Hive's float datatype is not supported by the Hive JDBC driver -- Key: HIVE-1861 URL: https://issues.apache.org/jira/browse/HIVE-1861 Project: Hive Issue Type: Bug

[jira] Resolved: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

2010-12-21 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi resolved HIVE-1856. -- Resolution: Fixed Fix Version/s: 0.7.0 Release Note: Backwards-compatible DROP behavior is

[jira] Updated: (HIVE-1852) Reduce unnecessary DFSClient.rename() calls

2010-12-21 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1852: - Attachment: HIVE-1852.6.patch Take Joy's comments. Also added one more test case for wildcard matching a

[jira] Commented: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

2010-12-21 Thread Jeff Hammerbacher (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12973998#action_12973998 ] Jeff Hammerbacher commented on HIVE-1856: - John: added your comments about patch

Review Request: HIVE-1696

2010-12-21 Thread John Sichi
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/189/ --- Review request for hive. Summary --- HIVE-1696 This addresses bug

[jira] Updated: (HIVE-1818) Call frequency and duration metrics for HiveMetaStore via jmx

2010-12-21 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1818: - Status: Patch Available (was: Open) Call frequency and duration metrics for HiveMetaStore via jmx

[jira] Commented: (HIVE-1806) The merge criteria on dynamic partitons should be per partiton

2010-12-21 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974101#action_12974101 ] Namit Jain commented on HIVE-1806: -- I will take a look The merge criteria on dynamic

[jira] Commented: (HIVE-1862) Revive partition filtering in the Hive MetaStore

2010-12-22 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974404#action_12974404 ] Ashutosh Chauhan commented on HIVE-1862: I can see four possible routes going

[jira] Commented: (HIVE-1862) Revive partition filtering in the Hive MetaStore

2010-12-22 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974409#action_12974409 ] Ashutosh Chauhan commented on HIVE-1862: Namit, Since HIVE-1853 is marked fixed and

[jira] Created: (HIVE-1863) Boolean columns in Hive tables containing NULL are treated as FALSE by the Hive JDBC driver.

2010-12-22 Thread Guy le Mar (JIRA)
Boolean columns in Hive tables containing NULL are treated as FALSE by the Hive JDBC driver. Key: HIVE-1863 URL: https://issues.apache.org/jira/browse/HIVE-1863

[jira] Commented: (HIVE-1806) The merge criteria on dynamic partitons should be per partiton

2010-12-22 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974543#action_12974543 ] Namit Jain commented on HIVE-1806: -- Comments for getMergeSize are wrong - that function

[jira] Created: (HIVE-1864) test load_overwrite.q fails

2010-12-22 Thread Namit Jain (JIRA)
test load_overwrite.q fails --- Key: HIVE-1864 URL: https://issues.apache.org/jira/browse/HIVE-1864 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain

[jira] Created: (HIVE-1865) redo zookeeper hive lock manager

2010-12-22 Thread Namit Jain (JIRA)
redo zookeeper hive lock manager Key: HIVE-1865 URL: https://issues.apache.org/jira/browse/HIVE-1865 Project: Hive Issue Type: Improvement Reporter: Namit Jain Assignee: Namit Jain

[jira] Updated: (HIVE-1865) redo zookeeper hive lock manager

2010-12-22 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1865: - Attachment: hive.1865.1.patch redo zookeeper hive lock manager

[jira] Updated: (HIVE-1806) The merge criteria on dynamic partitons should be per partiton

2010-12-22 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-1806: - Attachment: HIVE-1806.4.patch getMergeSize() could return 0 when there are multiple files generated but

[jira] Commented: (HIVE-1847) option of continue on error

2010-12-23 Thread Thiruvel Thirumoolan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974603#action_12974603 ] Thiruvel Thirumoolan commented on HIVE-1847: @Namit, i wasn't clear. The param

[jira] Assigned: (HIVE-1863) Boolean columns in Hive tables containing NULL are treated as FALSE by the Hive JDBC driver.

2010-12-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo reassigned HIVE-1863: - Assignee: Edward Capriolo Boolean columns in Hive tables containing NULL are treated as

[jira] Resolved: (HIVE-1847) option of continue on error

2010-12-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain resolved HIVE-1847. -- Resolution: Not A Problem Thanks Thiruvel option of continue on error ---

Re: Issue with map join

2010-12-23 Thread Namit Jain
Can you send the exact query along with the schema of the tables ? On 12/23/10 1:48 AM, jaydeep vishwakarma jaydeep.vishwaka...@mkhoj.com wrote: Hi, I am trying to running some MAPJOIN queries. When I am placing single table in MAP JOIN it works fine,But when I run same query with two tables

Build failed in Hudson: Hive-trunk-h0.20 #451

2010-12-23 Thread Apache Hudson Server
See https://hudson.apache.org/hudson/job/Hive-trunk-h0.20/451/changes Changes: [jssarma] HIVE-1852 Reduce unnecessary DFSClient.rename() calls (Ning Zhang via jssarma) -- [...truncated 14785 lines...] [junit] POSTHOOK: Output: defa...@srcbucket2

[jira] Commented: (HIVE-1863) Boolean columns in Hive tables containing NULL are treated as FALSE by the Hive JDBC driver.

2010-12-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974701#action_12974701 ] Edward Capriolo commented on HIVE-1863: --- Right. Something gets lost in translation

[jira] Commented: (HIVE-1806) The merge criteria on dynamic partitons should be per partiton

2010-12-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974713#action_12974713 ] Namit Jain commented on HIVE-1806: -- Mostly looks good - a minor comment. In the new test

[jira] Commented: (HIVE-1860) Hive's smallint datatype is not supported by the Hive JDBC driver

2010-12-23 Thread Steven Wong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974732#action_12974732 ] Steven Wong commented on HIVE-1860: --- This should have been fixed by HIVE-1378 in trunk

[jira] Commented: (HIVE-1861) Hive's float datatype is not supported by the Hive JDBC driver

2010-12-23 Thread Steven Wong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974731#action_12974731 ] Steven Wong commented on HIVE-1861: --- This should have been fixed by HIVE-1378 in trunk

[jira] Commented: (HIVE-1859) Hive's tinyint datatype is not supported by the Hive JDBC driver

2010-12-23 Thread Steven Wong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974733#action_12974733 ] Steven Wong commented on HIVE-1859: --- This should have been fixed by HIVE-1378 in trunk

[jira] Resolved: (HIVE-837) virtual column support (filename) in hive

2010-12-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-837. -- Resolution: Duplicate Duplicate of HIVE-417. We are working on adding another virtual column

[jira] Commented: (HIVE-837) virtual column support (filename) in hive

2010-12-23 Thread Amr Awadallah (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974739#action_12974739 ] Amr Awadallah commented on HIVE-837: I am out of office on vacation and will be slower

[jira] Resolved: (HIVE-822) HWI: propagate error messages all the way up to user interface

2010-12-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-822. -- Resolution: Duplicate Release Note: Duplication of HIVE-821 HWI: propagate error messages

[jira] Commented: (HIVE-901) Build Hive ODBC library with Autoconf/Automake

2010-12-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974751#action_12974751 ] Edward Capriolo commented on HIVE-901: -- Is there any licensing issues with bringing GPL

[jira] Commented: (HIVE-1806) The merge criteria on dynamic partitons should be per partiton

2010-12-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974752#action_12974752 ] Namit Jain commented on HIVE-1806: -- Thats fine +1 The merge criteria on dynamic

[jira] Resolved: (HIVE-1604) Patch to allow variables in Hive

2010-12-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1604. --- Resolution: Duplicate Release Note: Duplicate of HIVE-1096 1096 has been committed. We

[jira] Commented: (HIVE-901) Build Hive ODBC library with Autoconf/Automake

2010-12-23 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974757#action_12974757 ] Ning Zhang commented on HIVE-901: - @edward, I guess this JIRA is about making

[jira] Resolved: (HIVE-1623) Factor out Hadoop version check logic in bin/hive scripts

2010-12-23 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1623. --- Resolution: Duplicate I have an jira open to remove all pre-20 tweaks. This will be handled

[jira] Commented: (HIVE-901) Build Hive ODBC library with Autoconf/Automake

2010-12-23 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974767#action_12974767 ] Carl Steinbach commented on HIVE-901: - @Ed: The FSF makes a specific exception for

[jira] Reopened: (HIVE-1623) Factor out Hadoop version check logic in bin/hive scripts

2010-12-23 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach reopened HIVE-1623: -- @Ed: Please link a ticket to the duplicating ticket before resolving it as a duplicate. Factor

[jira] Commented: (HIVE-1456) potentail NullPointerException

2010-12-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974776#action_12974776 ] Namit Jain commented on HIVE-1456: -- +1 potentail NullPointerException

[jira] Assigned: (HIVE-1456) potentail NullPointerException

2010-12-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain reassigned HIVE-1456: Assignee: Alexey Diomin potentail NullPointerException --

[jira] Updated: (HIVE-1456) potentail NullPointerException

2010-12-23 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1456: - Resolution: Fixed Status: Resolved (was: Patch Available) Committed. Thanks Alexey potentail

[jira] Commented: (HIVE-1818) Call frequency and duration metrics for HiveMetaStore via jmx

2010-12-23 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974785#action_12974785 ] Paul Yang commented on HIVE-1818: - Taking a look Call frequency and duration metrics for

[jira] Assigned: (HIVE-1818) Call frequency and duration metrics for HiveMetaStore via jmx

2010-12-23 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Yang reassigned HIVE-1818: --- Assignee: Sushanth Sowmyan Call frequency and duration metrics for HiveMetaStore via jmx

[jira] Updated: (HIVE-1611) Add alternative search-provider to Hive site

2010-12-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1611: - Status: Open (was: Patch Available) Add alternative search-provider to Hive site

[jira] Created: (HIVE-1866) -101 should not swallow the exception.

2010-12-23 Thread He Yongqiang (JIRA)
-101 should not swallow the exception. --- Key: HIVE-1866 URL: https://issues.apache.org/jira/browse/HIVE-1866 Project: Hive Issue Type: Improvement Reporter: He Yongqiang The exception

[jira] Commented: (HIVE-1818) Call frequency and duration metrics for HiveMetaStore via jmx

2010-12-23 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974786#action_12974786 ] Paul Yang commented on HIVE-1818: - Sushanth, can you regenerate this patch against the

[jira] Updated: (HIVE-1818) Call frequency and duration metrics for HiveMetaStore via jmx

2010-12-23 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Yang updated HIVE-1818: Status: Open (was: Patch Available) Call frequency and duration metrics for HiveMetaStore via jmx

[jira] Updated: (HIVE-1806) The merge criteria on dynamic partitons should be per partiton

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

Review Request: HIVE-1262

2010-12-23 Thread John Sichi
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/192/ --- Review request for hive. Summary --- Review by JVS This addresses bug

Re: Review Request: HIVE-1262

2010-12-23 Thread John Sichi
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/192/#review79 ---

[jira] Updated: (HIVE-1262) Add security/checksum UDFs sha,crc32,md5,aes_encrypt, and aes_decrypt

2010-12-23 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1262: - Status: Open (was: Patch Available) Add security/checksum UDFs sha,crc32,md5,aes_encrypt, and

(HIVE-1642) Convert join queries to map-join based on size of table/row

2010-12-23 Thread ashu99
Hi, I set hive.auto.convert.join=true and run the following query: select t1.foo, count(t2.bar) from invites t1 join invites t2 on (t1.foo=t2.foo) group by t1.foo; I did not see it ran as map side join. Did I miss something? Is there any precondition for this feature to work? Thanks.

[jira] Updated: (HIVE-1858) Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF EXISTS

2010-12-23 Thread Marcel Kornacker (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marcel Kornacker updated HIVE-1858: --- Description: Extend HIVE-1856 to support IF EXISTS for {DROP TABLE, VIEW} and ALTER TABLE

[jira] Updated: (HIVE-1858) Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF EXISTS

2010-12-23 Thread Marcel Kornacker (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marcel Kornacker updated HIVE-1858: --- Attachment: hive-1858.1.patch Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF

Re: (HIVE-1642) Convert join queries to map-join based on size of table/row

2010-12-23 Thread Liyin Tang
Hi, How large is t1 and t2 ? if both of t1 and t2 is larger than 25M (a default threshold), the query processor will do the common join. Thanks Liyin On 23 December 2010 18:50, ash...@gmail.com wrote: Hi, I set hive.auto.convert.join=true and run the following query: select t1.foo,

Re: Review Request: HIVE-1262

2010-12-24 Thread Edward Capriolo
On 2010-12-23 16:04:03, John Sichi wrote: http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFAesDecrypt.java, line 37 https://reviews.apache.org/r/192/diff/1/?file=9231#file9231line37 Shouldn't this be deterministic=true? The

Build failed in Hudson: Hive-trunk-h0.20 #452

2010-12-24 Thread Apache Hudson Server
See https://hudson.apache.org/hudson/job/Hive-trunk-h0.20/452/changes Changes: [namit] HIVE-1806 Merge per dynamic partition based on size of each dynamic partition (Ning Zhang via namit) [namit] HIVE-1456 No need to check for LOG as null in sort-merge join (Alexey Diomin via namit)

[jira] Resolved: (HIVE-330) [Hive] implement UNION

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-330. -- Resolution: Duplicate Fix Version/s: 0.6.0 Unions have already been added

[jira] Commented: (HIVE-23) Hive should fail to start if it cannot get an instance of the filesystem

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-23?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974969#action_12974969 ] Edward Capriolo commented on HIVE-23: - I like how pig tries to connect to HDFS and JT and

[jira] Resolved: (HIVE-681) add UDF binary

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-681. -- Resolution: Duplicate Fix Version/s: 0.6.0 {noformat} hive describe function bin; OK

Re: Issue with map join

2010-12-24 Thread jaydeep vishwakarma
Hi Namit, Here is the query which I am trying to run :- select /*+ MAPJOIN(region,carrier ) */ region.reg,carrier.country,count(column1) from foo join carrier on (foo.column10 =carrier.id) join region on (carrier.country=region.country) where foo.rq_dt = '2010-12-16-00' AND carrier.rq_dt =

[jira] Resolved: (HIVE-22) Output invalid when choose all columns from left table of a join

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-22?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-22. - Resolution: Won't Fix {noformat} [med...@rs01 ~]$ cat a.txt 1ed 2stacey [med...@rs01 ~]$ cat b.txt

[jira] Reopened: (HIVE-1846) change hive assumption that local mode mappers/reducers always run in same jvm

2010-12-24 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach reopened HIVE-1846: -- Assignee: Joydeep Sen Sarma (was: Ramkumar Vadali) This patch is a causing a failure in

[jira] Resolved: (HIVE-1014) Ability to execute external scripts from within HiveCLI

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1014. --- Resolution: Duplicate Release Note: source was added in HIVE-1451 Ability to execute

[jira] Commented: (HIVE-967) Implement show create table

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12974980#action_12974980 ] Edward Capriolo commented on HIVE-967: -- @Carl. Are you still working on this. I have a

[jira] Resolved: (HIVE-1319) Alter table add partition fails if ADD PARTITION is not in upper case

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1319. --- Resolution: Invalid Alter table add partition fails if ADD PARTITION is not in upper case

[jira] Resolved: (HIVE-1815) The class HiveResultSet should implement batch fetching.

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1815. --- Resolution: Won't Fix Fix Version/s: 0.6.0 This is implemented vi

[jira] Resolved: (HIVE-1816) Reporting of (seemingly inconsequential) transport exception has major impact on performance

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1816. --- Resolution: Invalid Reporting of (seemingly inconsequential) transport exception has major

[jira] Resolved: (HIVE-1623) Factor out Hadoop version check logic in bin/hive scripts

2010-12-24 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1623. --- Resolution: Duplicate Factor out Hadoop version check logic in bin/hive scripts

[jira] Updated: (HIVE-1864) test load_overwrite.q fails

2010-12-24 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1864: - Attachment: HIVE-1864.1.patch.txt load_overwrite.q currently consists of the same block of

[jira] Updated: (HIVE-1864) test load_overwrite.q fails

2010-12-24 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1864: - Status: Patch Available (was: Open) test load_overwrite.q fails ---

[jira] Updated: (HIVE-1864) test load_overwrite.q fails

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

[jira] Updated: (HIVE-1867) Fix intermittent failures in TestNegativeCliDriver/dyn_part_empty.q

2010-12-24 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1867: - Description: {code} [junit] Begin query: dyn_part_empty.q [junit] Running

[jira] Updated: (HIVE-1867) Fix intermittent failures in TestNegativeCliDriver/dyn_part_empty.q

2010-12-24 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1867: - Priority: Major (was: Blocker) Fix intermittent failures in

[jira] Commented: (HIVE-1623) Factor out Hadoop version check logic in bin/hive scripts

2010-12-25 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975062#action_12975062 ] Edward Capriolo commented on HIVE-1623: --- @Carl. Sorry I will try to do this when I

[jira] Resolved: (HIVE-1391) Various issues when using MS-SQL2005 as the Hive Metastore

2010-12-25 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Edward Capriolo resolved HIVE-1391. --- Resolution: Won't Fix This is not an attempt to pass the buck. We do not officially support

Hudson build is back to normal : Hive-trunk-h0.20 #453

2010-12-25 Thread Apache Hudson Server
See https://hudson.apache.org/hudson/job/Hive-trunk-h0.20/453/changes

[jira] Commented: (HIVE-1864) test load_overwrite.q fails

2010-12-25 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975075#action_12975075 ] Carl Steinbach commented on HIVE-1864: -- @Ning: You're right. I just looked at your

[jira] Updated: (HIVE-967) Implement show create table

2010-12-25 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-967: Component/s: Query Processor Metastore Assignee: Edward Capriolo (was: Carl

[jira] Updated: (HIVE-1790) Patch to support HAVING clause in Hive

2010-12-25 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1790: - Status: Patch Available (was: Open) @Vaibhav: Please change the status of the ticket to patch

[jira] Updated: (HIVE-1790) Patch to support HAVING clause in Hive

2010-12-26 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1790: - Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch

Re: (HIVE-1642) Convert join queries to map-join based on size of table/row

2010-12-26 Thread ashu99
Thanks for the reply. I want to get clarification on this feature. If one of the two joining tables table t1 is smaller than 25M and is sharded, how does this feature work? Suppose there are joins on multiple tables such as t1, t2 and t3. If t1 and t2 are smaller than 25M and co-located with

Re: (HIVE-1642) Convert join queries to map-join based on size of table/row

2010-12-27 Thread Liyin Tang
Hi, If multiple tables join on different join keys, it will be separated into multiple MapRed Tasks. Also the threshold of the small table file size means the sum of all the small table. There is a documentation and a slide about this feature:

[jira] Commented: (HIVE-1858) Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF EXISTS

2010-12-27 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975308#action_12975308 ] John Sichi commented on HIVE-1858: -- +1. Will commit if tests pass. The wiki is going to

Re: Review Request: HIVE-1262

2010-12-27 Thread John Sichi
On 2010-12-23 16:04:03, John Sichi wrote: http://svn.apache.org/repos/asf/hive/trunk/common/src/java/org/apache/hadoop/hive/common/AesUtils.java, line 16 https://reviews.apache.org/r/192/diff/1/?file=9229#file9229line16 Here we may be chopping off a UTF-8 multibyte sequence in

[jira] Commented: (HIVE-1734) Implement map_keys() and map_values() UDFs

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975330#action_12975330 ] Carl Steinbach commented on HIVE-1734: -- @Eldon: Are you still working on this?

[jira] Updated: (HIVE-901) Build Hive C++ Client library with Autoconf/Automake

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-901: Description: In order to avoid more bugs like HIVE-898 it would be a good idea to build the C++

[jira] Updated: (HIVE-1858) Implement DROP {PARTITION, INDEX, TEMPORARY FUNCTION} IF EXISTS

2010-12-27 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1858: - Resolution: Fixed Fix Version/s: 0.7.0 Hadoop Flags: [Reviewed] Status: Resolved

Build failed in Hudson: Hive-trunk-h0.20 #455

2010-12-27 Thread Apache Hudson Server
See https://hudson.apache.org/hudson/job/Hive-trunk-h0.20/455/changes Changes: [cws] HIVE-1790 Support HAVING clause in Hive (Vaibhav Aggarwal via cws) -- [...truncated 14714 lines...] [junit] POSTHOOK: Output: defa...@srcbucket2 [junit] OK

[jira] Commented: (HIVE-7) Partition keys are still treated as strings irrespective of their defined type in runtime.

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12975409#action_12975409 ] Carl Steinbach commented on HIVE-7: --- Is this ticket stil valid? Partition keys are still

[jira] Resolved: (HIVE-985) Add Eclipse Launch Configuration for CliDriver

2010-12-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach resolved HIVE-985. - Resolution: Duplicate Add Eclipse Launch Configuration for CliDriver

<    6   7   8   9   10   11   12   13   14   15   >