[jira] Commented: (HIVE-1386) HiveQL SQL Compliance (Umbrella)

2010-06-08 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876556#action_12876556 ] Ning Zhang commented on HIVE-1386: -- @jeff, order by is already supported. In addition, I

table Partition

2010-06-08 Thread jaydeep vishwakarma
Hi, How many partitions at max we can create for a table? Suppose if I want to use date as a partition, Is it limited or unlimited ? Regards, jaydeep The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2010-06-08 Thread Prafulla Tekawade (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876676#action_12876676 ] Prafulla Tekawade commented on HIVE-417: He Yongqiang , Have you started working on

[jira] Commented: (HIVE-1386) HiveQL SQL Compliance (Umbrella)

2010-06-08 Thread Jeff Hammerbacher (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876716#action_12876716 ] Jeff Hammerbacher commented on HIVE-1386: - Ning: where?

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2010-06-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876717#action_12876717 ] He Yongqiang commented on HIVE-417: --- Cool. Yes. i do have a latest patch for this jira. I

Build failed in Hudson: Hive-trunk-h0.19 #465

2010-06-08 Thread Apache Hudson Server
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.19/465/ -- [...truncated 14075 lines...] [junit] OK [junit] Loading data to table srcbucket2 [junit] POSTHOOK: Output: defa...@srcbucket2 [junit] OK [junit] Loading data to

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

2010-06-08 Thread Apache Hudson Server
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.20/288/

[jira] Commented: (HIVE-1332) Archiving partitions

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876749#action_12876749 ] Namit Jain commented on HIVE-1332: -- Some tests failed - send a mail offline to Paul. Also,

[jira] Commented: (HIVE-1332) Archiving partitions

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876750#action_12876750 ] Namit Jain commented on HIVE-1332: -- Also, since the tests are anyway working only in hadoop

[jira] Commented: (HIVE-1332) Archiving partitions

2010-06-08 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876751#action_12876751 ] Paul Yang commented on HIVE-1332: - Well, we can't quite test using CHIF because users will

[jira] Created: (HIVE-1394) do not update transient_lastDdlTime if the partition is modified by a housekeeping operation

2010-06-08 Thread Namit Jain (JIRA)
do not update transient_lastDdlTime if the partition is modified by a housekeeping operation Key: HIVE-1394 URL: https://issues.apache.org/jira/browse/HIVE-1394

[jira] Commented: (HIVE-1332) Archiving partitions

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876770#action_12876770 ] Namit Jain commented on HIVE-1332: -- Otherwise, it looks good Archiving partitions

[jira] Created: (HIVE-1395) Table aliases are ambiguous

2010-06-08 Thread Adam Kramer (JIRA)
Table aliases are ambiguous --- Key: HIVE-1395 URL: https://issues.apache.org/jira/browse/HIVE-1395 Project: Hadoop Hive Issue Type: Bug Reporter: Adam Kramer Consider this query: SELECT a.num FROM (

[jira] Updated: (HIVE-1395) Table aliases are ambiguous

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1395: - Component/s: Query Processor Table aliases are ambiguous ---

[jira] Created: (HIVE-1396) Check for shared paths when specifying a location

2010-06-08 Thread Paul Yang (JIRA)
Check for shared paths when specifying a location - Key: HIVE-1396 URL: https://issues.apache.org/jira/browse/HIVE-1396 Project: Hadoop Hive Issue Type: Improvement Components:

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

2010-06-08 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-1129.1.patch I have attached a preliminary patch for this issue for

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

2010-06-08 Thread Mayank Lahiri (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876809#action_12876809 ] Mayank Lahiri commented on HIVE-1387: - The current implementation of percentile() seems

[jira] Created: (HIVE-1397) histogram() UDAF for a numerical column

2010-06-08 Thread Mayank Lahiri (JIRA)
histogram() UDAF for a numerical column --- Key: HIVE-1397 URL: https://issues.apache.org/jira/browse/HIVE-1397 Project: Hadoop Hive Issue Type: New Feature Components: Query Processor

[jira] Updated: (HIVE-417) Implement Indexing in Hive

2010-06-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-417: -- Attachment: hive-indexing.3.patch With this patch, the index can work. but it is not so intelligent.

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2010-06-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876827#action_12876827 ] He Yongqiang commented on HIVE-417: --- I forgot to add this line set

[jira] Resolved: (HIVE-1380) JDBC connection to be able to reattach to same session

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach resolved HIVE-1380. -- Resolution: Duplicate Duplicate of HIVE-1379 JDBC connection to be able to reattach to same

New JIRA component request: Drivers

2010-06-08 Thread Carl Steinbach
Hi, Can someone with the necessary privileges please add a Drivers component for JDBC and ODBC tickets to the Hive JIRA project? Thanks. Carl Reference: http://confluence.atlassian.com/display/JIRA/Defining+a+Component

Re: New JIRA component request: Drivers

2010-06-08 Thread Carl Steinbach
A UDF component would also be useful. Thanks. Carl On Tue, Jun 8, 2010 at 3:29 PM, Carl Steinbach c...@cloudera.com wrote: Hi, Can someone with the necessary privileges please add a Drivers component for JDBC and ODBC tickets to the Hive JIRA project? Thanks. Carl Reference:

[jira] Updated: (HIVE-1380) JDBC connection to be able to reattach to same session

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1380: - Labels: JDBC drivers (was: ) Affects Version/s: 0.5.0 JDBC connection to be able

[jira] Updated: (HIVE-1332) Archiving partitions

2010-06-08 Thread Paul Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Yang updated HIVE-1332: Attachment: HIVE-1332.6.patch This should fix the test issues - I'm re-running the test suite now but let

RE: New JIRA component request: Drivers

2010-06-08 Thread Namit Jain
Done -Original Message- From: Carl Steinbach [mailto:c...@cloudera.com] Sent: Tuesday, June 08, 2010 3:48 PM To: hive-dev@hadoop.apache.org Subject: Re: New JIRA component request: Drivers A UDF component would also be useful. Thanks. Carl On Tue, Jun 8, 2010 at 3:29 PM, Carl

[jira] Updated: (HIVE-1380) JDBC connection to be able to reattach to same session

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1380: - Component/s: Drivers JDBC connection to be able to reattach to same session

[jira] Updated: (HIVE-1379) JDBC connection to be able to reattach to same session

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1379: - Labels: JDBC drivers (was: ) Affects Version/s: 0.5.0 Component/s:

[jira] Updated: (HIVE-567) jdbc: integrate hive with pentaho report designer

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-567: Component/s: Drivers (was: Clients) jdbc: integrate hive with pentaho report

[jira] Updated: (HIVE-48) Support JDBC connections for interoperability between Hive and RDBMS

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-48?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-48: --- Component/s: Drivers (was: Clients) Support JDBC connections for interoperability

[jira] Updated: (HIVE-679) Integrate JDBC driver with SQuirrelSQL for querying

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-679: Component/s: Drivers (was: Clients) Integrate JDBC driver with SQuirrelSQL for

[jira] Updated: (HIVE-559) Support JDBC ResultSetMetadata

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-559: Affects Version/s: 0.5.0 Support JDBC ResultSetMetadata --

[jira] Updated: (HIVE-1381) Async cancel for JDBC connection.

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1381: - Affects Version/s: 0.5.0 Component/s: Drivers Async cancel for JDBC connection.

[jira] Updated: (HIVE-559) Support JDBC ResultSetMetadata

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-559: Component/s: Drivers (was: Clients) Support JDBC ResultSetMetadata

[jira] Updated: (HIVE-576) complete jdbc driver

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-576: Component/s: Drivers (was: Clients) complete jdbc driver

[jira] Updated: (HIVE-381) [JDBC component] HiveResultSet next() always returned true due to bad string comparison

2010-06-08 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-381: Component/s: Drivers [JDBC component] HiveResultSet next() always returned true due to bad string

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

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1387: - Status: Open (was: Patch Available) Make PERCENTILE work with double data type

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

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain reassigned HIVE-1387: Assignee: Mayank Lahiri Make PERCENTILE work with double data type

[jira] Updated: (HIVE-1383) allow HBase WAL to be disabled

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1383: - Status: Open (was: Patch Available) allow HBase WAL to be disabled --

[jira] Updated: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1368: - Status: Resolved (was: Patch Available) Resolution: Duplicate Duplicate of

[jira] Issue Comment Edited: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

2010-06-08 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12876893#action_12876893 ] Namit Jain edited comment on HIVE-1368 at 6/8/10 8:10 PM: --

hive developers meeting at Facebook on June 1' 2010

2010-06-08 Thread Namit Jain
We had hive developer's first meeting at Facebook on June 1. I am sorry for sending the meeting notes late. The following people were present: Facebook (Paul Yang; Ning Zhang; Yongqiang He; Ahmed Aly; John Sichi; Ashish Thusoo; Namit Jain) Netflix (Eva Tse; Jerome Boulon) Cloudera (Arvind

Announcing the next Hive Developer Meeting, Tuesday July 6th, 3-5pm @ Cloudera

2010-06-08 Thread Carl Steinbach
The next Hive Developer Meeting will be held on Tuesday, July 6th from 3-5pm at Cloudera's offices in Palo Alto. All Hive contributors are invited to attend! What: Hive Developer Meeting When: Tuesday July 6th, 3-5pm Where: Cloudera 210 Portage Avenue Palo Alto, CA

Re: Announcing the next Hive Developer Meeting, Tuesday July 6th, 3-5pm @ Cloudera

2010-06-08 Thread Carl Steinbach
If you plan to attend please RSVP here: http://www.meetup.com/Hive-Contributors-Group Thanks. Carl On Tue, Jun 8, 2010 at 5:46 PM, Carl Steinbach c...@cloudera.com wrote: The next Hive Developer Meeting will be held on Tuesday, July 6th from 3-5pm at Cloudera's offices in Palo Alto. All Hive

[jira] Updated: (HIVE-1332) Archiving partitions

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

Re: table Partition

2010-06-08 Thread Edward Capriolo
There is no theoretical limit. Practically, the query planning phase involves reading the partition from the metastore (derby, mysql). At some point, when your query spans tons of partitions, the query planning phase can take 2 minutes or more. Edward On Tue, Jun 8, 2010 at 3:00 AM, jaydeep

RE: [jira] Updated: (HIVE-559) Support JDBC ResultSetMetadata

2010-06-08 Thread wuxy
I found following section at the end of chapter 6 of the book Hadoop, the definitive guide, 'Task side-effect files'; Care needs to be taken to ensure that multiple instances of the same task don't try to write to the same file. There are two problems to avoid: if a task