[jira] [Updated] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Zhenxiao Luo (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhenxiao Luo updated HIVE-3140:
---

Attachment: HIVE-3140.1.patch.txt

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Assigned] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Zhenxiao Luo (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhenxiao Luo reassigned HIVE-3140:
--

Assignee: Zhenxiao Luo

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
Assignee: Zhenxiao Luo
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Zhenxiao Luo (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510350#comment-13510350
 ] 

Zhenxiao Luo commented on HIVE-3140:


Review Request submitted at:
https://phabricator.fb.com/D648742

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3073) Hive List Bucketing - DML support

2012-12-05 Thread Gang Tim Liu (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Gang Tim Liu updated HIVE-3073:
---

Attachment: HIVE-3073.patch.27

 Hive List Bucketing - DML support 
 --

 Key: HIVE-3073
 URL: https://issues.apache.org/jira/browse/HIVE-3073
 Project: Hive
  Issue Type: New Feature
  Components: SQL
Affects Versions: 0.10.0
Reporter: Gang Tim Liu
Assignee: Gang Tim Liu
 Attachments: HIVE-3073.patch.12, HIVE-3073.patch.13, 
 HIVE-3073.patch.15, HIVE-3073.patch.18, HIVE-3073.patch.19, 
 HIVE-3073.patch.21, HIVE-3073.patch.22, HIVE-3073.patch.24, 
 HIVE-3073.patch.26, HIVE-3073.patch.27


 If a hive table column has skewed keys, query performance on non-skewed key 
 is always impacted. Hive List Bucketing feature will address it:
 https://cwiki.apache.org/Hive/listbucketing.html
 This jira issue will track DML change for the feature:
 1. single skewed column
 2. manual load data

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3594) When Group by Partition Column Type is Timestamp or STRING Which Format contains HH:MM:SS, It will occur URISyntaxException

2012-12-05 Thread Navis (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Navis updated HIVE-3594:


Affects Version/s: (was: 0.9.0)
   Status: Patch Available  (was: Open)

 When Group by Partition Column Type is Timestamp or STRING Which Format 
 contains HH:MM:SS, It will occur URISyntaxException
 -

 Key: HIVE-3594
 URL: https://issues.apache.org/jira/browse/HIVE-3594
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Daisy.Yuan
Assignee: Navis
 Attachments: HIVE-3594.D6081.1.patch, HIVE-3594.D6081.2.patch


 create table test (no int, name string) partitioned by (pts string) row 
 format delimited fields terminated by ' '; 
 load data local inpath '/opt/files/groupbyts1.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts2.txt' into table test 
 partition(pts='21:25:12');
 load data local inpath '/opt/files/groupbyts3.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts4.txt' into table test 
 partition(pts='21:25:12');
 when I execute “select * from test group by pts;”, it will occur as follows 
 exception.
  at org.apache.hadoop.fs.Path.initialize(Path.java:157)
 at org.apache.hadoop.fs.Path.init(Path.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.Utilities.getInputSummary(Utilities.java:1667)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfReducers(MapRedTask.java:432)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.setNumberOfReducers(MapRedTask.java:400)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:93)
 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1329)
 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1121)
 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:954)
 at 
 org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:198)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:630)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:618)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
 at 
 org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 at java.lang.Thread.run(Thread.java:662)
 Caused by: java.net.URISyntaxException: Relative path in absolute URI: 
 fake-path-metadata-only-query-default.test{pts=12:11:30%7D
 at java.net.URI.checkPath(URI.java:1788)
 at java.net.URI.init(URI.java:734)
 at org.apache.hadoop.fs.Path.initialize(Path.java:154)
 ... 19 more
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.MapRedTask
 When PhysicalOptimizer optimizes GroupByOperator, according to default 
 parameters hive.optimize.metadataonly = true, MetadataOnlyOptimizer will be 
 enabled. The MetadataOnlyOptimizer will change the partition alias desc. The 
 partition alies hdfs://ip:9000/user/hive/warehouse/test/pts=12%3A11%3A30 is 
 changed into  
 fake-path-metadata-only-query-default.test{pts=12:11:30}. When construct uri 
 through new partition alies, it must occur java.net.URISyntaxException. 
  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3594) When Group by Partition Column Type is Timestamp or STRING Which Format contains HH:MM:SS, It will occur URISyntaxException

2012-12-05 Thread Phabricator (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-3594:
--

Attachment: HIVE-3594.D6081.2.patch

navis updated the revision HIVE-3594 [jira] When Group by Partition Column 
Type is Timestamp or STRING Which Format contains HH:MM:SS, It will occur 
URISyntaxException.
Reviewers: JIRA

  Replaced URLEncoder to String.replaceAll([:/#\\?], _)


REVISION DETAIL
  https://reviews.facebook.net/D6081

AFFECTED FILES
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/MetadataOnlyOptimizer.java
  ql/src/test/queries/clientpositive/metadataonly1.q
  ql/src/test/results/clientpositive/metadataonly1.q.out

To: JIRA, navis


 When Group by Partition Column Type is Timestamp or STRING Which Format 
 contains HH:MM:SS, It will occur URISyntaxException
 -

 Key: HIVE-3594
 URL: https://issues.apache.org/jira/browse/HIVE-3594
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Daisy.Yuan
Assignee: Navis
 Attachments: HIVE-3594.D6081.1.patch, HIVE-3594.D6081.2.patch


 create table test (no int, name string) partitioned by (pts string) row 
 format delimited fields terminated by ' '; 
 load data local inpath '/opt/files/groupbyts1.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts2.txt' into table test 
 partition(pts='21:25:12');
 load data local inpath '/opt/files/groupbyts3.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts4.txt' into table test 
 partition(pts='21:25:12');
 when I execute “select * from test group by pts;”, it will occur as follows 
 exception.
  at org.apache.hadoop.fs.Path.initialize(Path.java:157)
 at org.apache.hadoop.fs.Path.init(Path.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.Utilities.getInputSummary(Utilities.java:1667)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfReducers(MapRedTask.java:432)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.setNumberOfReducers(MapRedTask.java:400)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:93)
 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1329)
 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1121)
 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:954)
 at 
 org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:198)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:630)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:618)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
 at 
 org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 at java.lang.Thread.run(Thread.java:662)
 Caused by: java.net.URISyntaxException: Relative path in absolute URI: 
 fake-path-metadata-only-query-default.test{pts=12:11:30%7D
 at java.net.URI.checkPath(URI.java:1788)
 at java.net.URI.init(URI.java:734)
 at org.apache.hadoop.fs.Path.initialize(Path.java:154)
 ... 19 more
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.MapRedTask
 When PhysicalOptimizer optimizes GroupByOperator, according to default 
 parameters hive.optimize.metadataonly = true, MetadataOnlyOptimizer will be 
 enabled. The MetadataOnlyOptimizer will change the partition alias desc. The 
 partition alies hdfs://ip:9000/user/hive/warehouse/test/pts=12%3A11%3A30 is 
 changed into  
 fake-path-metadata-only-query-default.test{pts=12:11:30}. When construct uri 
 through new partition alies, it must occur java.net.URISyntaxException. 
  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-2477) Use name of original expression for name of CAST output

2012-12-05 Thread Navis (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Navis updated HIVE-2477:


Status: Patch Available  (was: Open)

 Use name of original expression for name of CAST output
 ---

 Key: HIVE-2477
 URL: https://issues.apache.org/jira/browse/HIVE-2477
 Project: Hive
  Issue Type: Improvement
Reporter: Adam Kramer
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2477.1.patch.txt, HIVE-2477.D7161.1.patch


 CAST(foo AS INT)
 should, by default, consider itself a column named foo if 
 unspecified/unaliased.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-2477) Use name of original expression for name of CAST output

2012-12-05 Thread Phabricator (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-2477:
--

Attachment: HIVE-2477.D7161.1.patch

navis requested code review of HIVE-2477 [jira] Use name of original 
expression for name of CAST output.
Reviewers: JIRA

  DPAL-642 Use name of original expression for name of CAST output

  CAST(foo AS INT)
  should, by default, consider itself a column named foo if 
unspecified/unaliased.

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D7161

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/test/queries/clientpositive/alias_casted_column.q
  ql/src/test/queries/clientpositive/alias_unary_function.q
  ql/src/test/results/clientpositive/alias_unary_function.q.out
  ql/src/test/results/compiler/plan/input_testxpath2.q.xml

MANAGE HERALD DIFFERENTIAL RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/16953/

To: JIRA, navis


 Use name of original expression for name of CAST output
 ---

 Key: HIVE-2477
 URL: https://issues.apache.org/jira/browse/HIVE-2477
 Project: Hive
  Issue Type: Improvement
Reporter: Adam Kramer
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2477.1.patch.txt, HIVE-2477.D7161.1.patch


 CAST(foo AS INT)
 should, by default, consider itself a column named foo if 
 unspecified/unaliased.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3073) Hive List Bucketing - DML support

2012-12-05 Thread Namit Jain (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510366#comment-13510366
 ] 

Namit Jain commented on HIVE-3073:
--

+1

looks good, running tests

 Hive List Bucketing - DML support 
 --

 Key: HIVE-3073
 URL: https://issues.apache.org/jira/browse/HIVE-3073
 Project: Hive
  Issue Type: New Feature
  Components: SQL
Affects Versions: 0.10.0
Reporter: Gang Tim Liu
Assignee: Gang Tim Liu
 Attachments: HIVE-3073.patch.12, HIVE-3073.patch.13, 
 HIVE-3073.patch.15, HIVE-3073.patch.18, HIVE-3073.patch.19, 
 HIVE-3073.patch.21, HIVE-3073.patch.22, HIVE-3073.patch.24, 
 HIVE-3073.patch.26, HIVE-3073.patch.27


 If a hive table column has skewed keys, query performance on non-skewed key 
 is always impacted. Hive List Bucketing feature will address it:
 https://cwiki.apache.org/Hive/listbucketing.html
 This jira issue will track DML change for the feature:
 1. single skewed column
 2. manual load data

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3728) make optimizing multi-group by configurable

2012-12-05 Thread Namit Jain (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510410#comment-13510410
 ] 

Namit Jain commented on HIVE-3728:
--

https://reviews.facebook.net/D7167


 make optimizing multi-group by configurable
 ---

 Key: HIVE-3728
 URL: https://issues.apache.org/jira/browse/HIVE-3728
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Namit Jain
Assignee: Namit Jain

 This was done as part of https://issues.apache.org/jira/browse/HIVE-609.
 This should be configurable.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3728) make optimizing multi-group by configurable

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3728:
-

Attachment: hive.3178.1.patch

 make optimizing multi-group by configurable
 ---

 Key: HIVE-3728
 URL: https://issues.apache.org/jira/browse/HIVE-3728
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Namit Jain
Assignee: Namit Jain
 Attachments: hive.3178.1.patch


 This was done as part of https://issues.apache.org/jira/browse/HIVE-609.
 This should be configurable.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Created] (HIVE-3773) Share input scan by unions across multiple queries

2012-12-05 Thread Namit Jain (JIRA)
Namit Jain created HIVE-3773:


 Summary: Share input scan by unions across multiple queries
 Key: HIVE-3773
 URL: https://issues.apache.org/jira/browse/HIVE-3773
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
Reporter: Namit Jain
Assignee: Namit Jain


Consider a query like:


select * from
(
  select key, 1 as value, count(1) from src group by key
union all
  select 1 as key, value, count(1) from src group by value
union all
  select key, value, count(1) from src group by key, value
) s;


src is scanned multiple times currently (one per sub-query).
This should be treated like a multi-table insert by the optimizer.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3073) Hive List Bucketing - DML support

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3073:
-

  Resolution: Fixed
Hadoop Flags: Reviewed
  Status: Resolved  (was: Patch Available)

Committed. Thanks Tim

 Hive List Bucketing - DML support 
 --

 Key: HIVE-3073
 URL: https://issues.apache.org/jira/browse/HIVE-3073
 Project: Hive
  Issue Type: New Feature
  Components: SQL
Affects Versions: 0.10.0
Reporter: Gang Tim Liu
Assignee: Gang Tim Liu
 Attachments: HIVE-3073.patch.12, HIVE-3073.patch.13, 
 HIVE-3073.patch.15, HIVE-3073.patch.18, HIVE-3073.patch.19, 
 HIVE-3073.patch.21, HIVE-3073.patch.22, HIVE-3073.patch.24, 
 HIVE-3073.patch.26, HIVE-3073.patch.27


 If a hive table column has skewed keys, query performance on non-skewed key 
 is always impacted. Hive List Bucketing feature will address it:
 https://cwiki.apache.org/Hive/listbucketing.html
 This jira issue will track DML change for the feature:
 1. single skewed column
 2. manual load data

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3073) Hive List Bucketing - DML support

2012-12-05 Thread Gang Tim Liu (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510536#comment-13510536
 ] 

Gang Tim Liu commented on HIVE-3073:


Namit thank you so much Tim




 Hive List Bucketing - DML support 
 --

 Key: HIVE-3073
 URL: https://issues.apache.org/jira/browse/HIVE-3073
 Project: Hive
  Issue Type: New Feature
  Components: SQL
Affects Versions: 0.10.0
Reporter: Gang Tim Liu
Assignee: Gang Tim Liu
 Attachments: HIVE-3073.patch.12, HIVE-3073.patch.13, 
 HIVE-3073.patch.15, HIVE-3073.patch.18, HIVE-3073.patch.19, 
 HIVE-3073.patch.21, HIVE-3073.patch.22, HIVE-3073.patch.24, 
 HIVE-3073.patch.26, HIVE-3073.patch.27


 If a hive table column has skewed keys, query performance on non-skewed key 
 is always impacted. Hive List Bucketing feature will address it:
 https://cwiki.apache.org/Hive/listbucketing.html
 This jira issue will track DML change for the feature:
 1. single skewed column
 2. manual load data

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3728) make optimizing multi-group by configurable

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3728:
-

Attachment: hive.3728.2.patch

 make optimizing multi-group by configurable
 ---

 Key: HIVE-3728
 URL: https://issues.apache.org/jira/browse/HIVE-3728
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Namit Jain
Assignee: Namit Jain
 Attachments: hive.3178.1.patch, hive.3728.2.patch


 This was done as part of https://issues.apache.org/jira/browse/HIVE-609.
 This should be configurable.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3728) make optimizing multi-group by configurable

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3728:
-

Attachment: (was: hive.3178.1.patch)

 make optimizing multi-group by configurable
 ---

 Key: HIVE-3728
 URL: https://issues.apache.org/jira/browse/HIVE-3728
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Namit Jain
Assignee: Namit Jain
 Attachments: hive.3728.2.patch


 This was done as part of https://issues.apache.org/jira/browse/HIVE-609.
 This should be configurable.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3648) HiveMetaStoreFsImpl is not compatible with hadoop viewfs

2012-12-05 Thread Arup Malakar (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510799#comment-13510799
 ] 

Arup Malakar commented on HIVE-3648:


Thanks Ashutosh.

 HiveMetaStoreFsImpl is not compatible with hadoop viewfs
 

 Key: HIVE-3648
 URL: https://issues.apache.org/jira/browse/HIVE-3648
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 0.9.0, 0.10.0
Reporter: Kihwal Lee
Assignee: Arup Malakar
 Fix For: 0.11

 Attachments: HIVE_3648_branch_0.patch, HIVE_3648_branch_1.patch, 
 HIVE-3648-trunk-0.patch, HIVE_3648_trunk_1.patch, HIVE-3648-trunk-1.patch


 HiveMetaStoreFsImpl#deleteDir() method calls Trash#moveToTrash(). This may 
 not work when viewfs is used. It needs to call Trash#moveToAppropriateTrash() 
 instead.  Please note that this method is not available in hadoop versions 
 earlier than 0.23.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3702) Renaming table changes table location scheme/authority

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510874#comment-13510874
 ] 

Hudson commented on HIVE-3702:
--

Integrated in Hive-trunk-h0.21 #1834 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1834/])
HIVE-3702 Renaming table changes table location scheme/authority
(Kevin Wilfong via namit) (Revision 1416875)

 Result = ABORTED
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1416875
Files : 
* 
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveAlterHandler.java
* 
/hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/hooks/VerifyOutputTableLocationSchemeIsFileHook.java
* /hive/trunk/ql/src/test/queries/clientpositive/rename_table_location.q
* /hive/trunk/ql/src/test/results/clientpositive/rename_table_location.q.out


 Renaming table changes table location scheme/authority
 --

 Key: HIVE-3702
 URL: https://issues.apache.org/jira/browse/HIVE-3702
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 0.9.0
Reporter: Kevin Wilfong
Assignee: Kevin Wilfong
 Attachments: HIVE-3702.1.patch.txt, HIVE-3702.2.patch.txt


 Renaming a table changes the location of the table to the default location of 
 the database, followed by the table name.  This means that if the default 
 location of the database uses a different scheme/authority, an exception will 
 get thrown attempting to move the data.
 Instead, the table's location should be made the default location of the 
 database followed by the table name, but using the original location's scheme 
 and authority.
 This only applies for managed tables, and there is already a check to ensure 
 the new location doesn't already exist.
 This is analogous to what was done for partitions in HIVE-2875

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3384) HIVE JDBC module won't compile under JDK1.7 as new methods added in JDBC specification

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510873#comment-13510873
 ] 

Hudson commented on HIVE-3384:
--

Integrated in Hive-trunk-h0.21 #1834 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1834/])
HIVE-3384 : HIVE JDBC module won't compile under JDK1.7 as new methods 
added in JDBC specification (Shengsheng Huang, Chris Drome, Mikhail Bautin via 
Ashutosh Chauhan) (Revision 1417235)

 Result = ABORTED
hashutosh : 
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417235
Files : 
* /hive/trunk/build-common.xml
* /hive/trunk/build.properties
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveBaseResultSet.java
* 
/hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveCallableStatement.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveConnection.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDataSource.java
* 
/hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDatabaseMetaData.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDriver.java
* 
/hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HivePreparedStatement.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveQueryResultSet.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveStatement.java
* /hive/trunk/metastore/build.xml
* /hive/trunk/pdk/scripts/build-plugin.xml


 HIVE JDBC module won't compile under JDK1.7 as new methods added in JDBC 
 specification
 --

 Key: HIVE-3384
 URL: https://issues.apache.org/jira/browse/HIVE-3384
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Reporter: Weidong Bian
Assignee: Mikhail Bautin
Priority: Minor
 Fix For: 0.11

 Attachments: D6873-0.9.1.patch, D6873.1.patch, D6873.2.patch, 
 D6873.3.patch, D6873.4.patch, D6873.5.patch, D6873.6.patch, D6873.7.patch, 
 HIVE-3384-2012-12-02.patch, HIVE-3384-2012-12-04.patch, HIVE-3384.2.patch, 
 HIVE-3384-branch-0.9.patch, HIVE-3384.patch, HIVE-JDK7-JDBC.patch


 jdbc module couldn't be compiled with jdk7 as it adds some abstract method in 
 the JDBC specification 
 some error info:
  error: HiveCallableStatement is not abstract and does not override abstract
 method TgetObject(String,ClassT) in CallableStatement
 .
 .
 .

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3073) Hive List Bucketing - DML support

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510875#comment-13510875
 ] 

Hudson commented on HIVE-3073:
--

Integrated in Hive-trunk-h0.21 #1834 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1834/])
HIVE-3073 Hive List Bucketing - DML support
(Gang Tim Liu via namit) (Revision 1417374)

 Result = ABORTED
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417374
Files : 
* /hive/trunk/common/src/java/org/apache/hadoop/hive/common/FileUtils.java
* /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
* /hive/trunk/conf/hive-default.xml.template
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/MoveTask.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/StatsTask.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/rcfile/merge/BlockMergeTask.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/rcfile/merge/MergeWork.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/rcfile/merge/RCFileMergeMapper.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Partition.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRFileSink1.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/PrunerOperatorFactory.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/listbucketingpruner/ListBucketingPruner.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/listbucketingpruner/ListBucketingPrunerUtils.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/AlterTablePartMergeFilesDesc.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/FileSinkDesc.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ListBucketingCtx.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/LoadTableDesc.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java
* /hive/trunk/ql/src/test/queries/clientnegative/column_change_skewedcol_type1.q
* /hive/trunk/ql/src/test/queries/clientnegative/column_rename5.q
* 
/hive/trunk/ql/src/test/queries/clientnegative/create_skewed_table_col_name_value_no_mismatch.q
* 
/hive/trunk/ql/src/test/queries/clientnegative/create_skewed_table_dup_col_name.q
* 
/hive/trunk/ql/src/test/queries/clientnegative/create_skewed_table_failure_invalid_col_name.q
* /hive/trunk/ql/src/test/queries/clientnegative/invalid_config1.q
* /hive/trunk/ql/src/test/queries/clientnegative/load_stored_as_dirs.q
* /hive/trunk/ql/src/test/queries/clientpositive/alter_skewed_table.q
* 
/hive/trunk/ql/src/test/queries/clientpositive/create_alter_list_bucketing_table1.q
* /hive/trunk/ql/src/test/queries/clientpositive/create_skewed_table1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_3.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_4.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_5.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_6.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_7.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_8.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_9.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_multiskew_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_multiskew_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_multiskew_3.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_oneskew_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_oneskew_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_oneskew_3.q
* /hive/trunk/ql/src/test/results/clientnegative/invalid_config1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
* 

[jira] [Commented] (HIVE-3750) JDBCStatsPublisher fails when ID length exceeds length of ID column

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510876#comment-13510876
 ] 

Hudson commented on HIVE-3750:
--

Integrated in Hive-trunk-h0.21 #1834 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1834/])
HIVE-3771 HIVE-3750 broke TestParse
(Kevin Wilfong via namit) (Revision 1417294)

 Result = ABORTED
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417294
Files : 
* /hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input7.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input9.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input_testsequencefile.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample7.q.xml


 JDBCStatsPublisher fails when ID length exceeds length of ID column
 ---

 Key: HIVE-3750
 URL: https://issues.apache.org/jira/browse/HIVE-3750
 Project: Hive
  Issue Type: Bug
  Components: Statistics
Affects Versions: 0.11
Reporter: Kevin Wilfong
Assignee: Kevin Wilfong
 Attachments: HIVE-3750.1.patch.txt


 When the length of the ID field passed to JDBCStatsPublisher exceeds the 
 length of the column in the table (currently 255 characters) stats collection 
 fails.  This causes the entire query to fail when hive.stats.reliable is set 
 to true.
 One way to prevent this would be to calculate a deterministic, very low 
 collision hash of the ID prefix used for aggregation and use that when the 
 length of the ID is too long.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3771) HIVE-3750 broke TestParse

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13510877#comment-13510877
 ] 

Hudson commented on HIVE-3771:
--

Integrated in Hive-trunk-h0.21 #1834 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1834/])
HIVE-3771 HIVE-3750 broke TestParse
(Kevin Wilfong via namit) (Revision 1417294)

 Result = ABORTED
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417294
Files : 
* /hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input7.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input9.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input_testsequencefile.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample7.q.xml


 HIVE-3750 broke TestParse
 -

 Key: HIVE-3771
 URL: https://issues.apache.org/jira/browse/HIVE-3771
 Project: Hive
  Issue Type: Bug
  Components: Testing Infrastructure
Affects Versions: 0.11
Reporter: Kevin Wilfong
Assignee: Kevin Wilfong
 Attachments: HIVE-3771.1.patch.txt


 see title

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3648) HiveMetaStoreFsImpl is not compatible with hadoop viewfs

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511005#comment-13511005
 ] 

Hudson commented on HIVE-3648:
--

Integrated in Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false #219 (See 
[https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/])
HIVE-3648 : HiveMetaStoreFsImpl is not compatible with hadoop viewfs (Arup 
Malakar via Ashutosh Chauhan) (Revision 1417267)

 Result = FAILURE
hashutosh : 
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417267
Files : 
* 
/hive/branches/branch-0.9/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStoreFsImpl.java
* 
/hive/branches/branch-0.9/shims/src/0.20/java/org/apache/hadoop/hive/shims/Hadoop20Shims.java
* 
/hive/branches/branch-0.9/shims/src/0.20S/java/org/apache/hadoop/hive/shims/Hadoop20SShims.java
* 
/hive/branches/branch-0.9/shims/src/0.23/java/org/apache/hadoop/hive/shims/Hadoop23Shims.java
* 
/hive/branches/branch-0.9/shims/src/common-secure/java/org/apache/hadoop/hive/shims/HadoopShimsSecure.java
* 
/hive/branches/branch-0.9/shims/src/common/java/org/apache/hadoop/hive/shims/HadoopShims.java


 HiveMetaStoreFsImpl is not compatible with hadoop viewfs
 

 Key: HIVE-3648
 URL: https://issues.apache.org/jira/browse/HIVE-3648
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 0.9.0, 0.10.0
Reporter: Kihwal Lee
Assignee: Arup Malakar
 Fix For: 0.11

 Attachments: HIVE_3648_branch_0.patch, HIVE_3648_branch_1.patch, 
 HIVE-3648-trunk-0.patch, HIVE_3648_trunk_1.patch, HIVE-3648-trunk-1.patch


 HiveMetaStoreFsImpl#deleteDir() method calls Trash#moveToTrash(). This may 
 not work when viewfs is used. It needs to call Trash#moveToAppropriateTrash() 
 instead.  Please note that this method is not available in hadoop versions 
 earlier than 0.23.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3645) RCFileWriter does not implement the right function to support Federation

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511006#comment-13511006
 ] 

Hudson commented on HIVE-3645:
--

Integrated in Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false #219 (See 
[https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/])
HIVE-3645 : RCFileWriter does not implement the right function to support 
Federation (Arup Malakar via Ashutosh Chauhan) (Revision 1417220)

 Result = FAILURE
hashutosh : 
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417220
Files : 
* /hive/branches/branch-0.9/ql/src/java/org/apache/hadoop/hive/ql/io/RCFile.java
* 
/hive/branches/branch-0.9/shims/src/0.20/java/org/apache/hadoop/hive/shims/Hadoop20Shims.java
* 
/hive/branches/branch-0.9/shims/src/0.20S/java/org/apache/hadoop/hive/shims/Hadoop20SShims.java
* 
/hive/branches/branch-0.9/shims/src/0.23/java/org/apache/hadoop/hive/shims/Hadoop23Shims.java
* 
/hive/branches/branch-0.9/shims/src/common-secure/java/org/apache/hadoop/hive/shims/HadoopShimsSecure.java
* 
/hive/branches/branch-0.9/shims/src/common/java/org/apache/hadoop/hive/shims/HadoopShims.java


 RCFileWriter does not implement the right function to support Federation
 

 Key: HIVE-3645
 URL: https://issues.apache.org/jira/browse/HIVE-3645
 Project: Hive
  Issue Type: Bug
  Components: Serializers/Deserializers
Affects Versions: 0.9.0, 0.10.0
 Environment: Hadoop 0.23.3 federation, Hive 0.9 and Pig 0.10
Reporter: Viraj Bhat
Assignee: Arup Malakar
 Fix For: 0.11

 Attachments: HIVE_3645_branch_0.patch, HIVE_3645_trunk_0.patch


 Create a table using Hive DDL
 {code}
 CREATE TABLE tmp_hcat_federated_numbers_part_1 (
   id   int,  
   intnum   int,
   floatnum float
 )partitioned by (
   part1string,
   part2string
 )
 STORED AS rcfile
 LOCATION 'viewfs:///database/tmp_hcat_federated_numbers_part_1';
 {code}
 Populate it using Pig:
 {code}
 A = load 'default.numbers_pig' using org.apache.hcatalog.pig.HCatLoader();
 B = filter A by id =  500;
 C = foreach B generate (int)id, (int)intnum, (float)floatnum;
 store C into
 'default.tmp_hcat_federated_numbers_part_1'
 using org.apache.hcatalog.pig.HCatStorer
('part1=pig, part2=hcat_pig_insert',
 'id: int,intnum: int,floatnum: float');
 {code}
 Generates the following error when running on a Federated Cluster:
 {quote}
 2012-10-29 20:40:25,011 [main] ERROR
 org.apache.pig.tools.pigstats.SimplePigStats - ERROR 2997: Unable to recreate
 exception from backed error: AttemptID:attempt_1348522594824_0846_m_00_3
 Info:Error: org.apache.hadoop.fs.viewfs.NotInMountpointException:
 getDefaultReplication on empty path is invalid
 at
 org.apache.hadoop.fs.viewfs.ViewFileSystem.getDefaultReplication(ViewFileSystem.java:479)
 at org.apache.hadoop.hive.ql.io.RCFile$Writer.init(RCFile.java:723)
 at org.apache.hadoop.hive.ql.io.RCFile$Writer.init(RCFile.java:705)
 at
 org.apache.hadoop.hive.ql.io.RCFileOutputFormat.getRecordWriter(RCFileOutputFormat.java:86)
 at
 org.apache.hcatalog.mapreduce.FileOutputFormatContainer.getRecordWriter(FileOutputFormatContainer.java:100)
 at
 org.apache.hcatalog.mapreduce.HCatOutputFormat.getRecordWriter(HCatOutputFormat.java:228)
 at
 org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.PigOutputFormat.getRecordWriter(PigOutputFormat.java:84)
 at
 org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.init(MapTask.java:587)
 at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:706)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
 at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:157)
 at java.security.AccessController.doPrivileged(Native Method)
 at javax.security.auth.Subject.doAs(Subject.java:396)
 at
 org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1212)
 at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:152)
 {quote}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


Build failed in Jenkins: Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false #219

2012-12-05 Thread Apache Jenkins Server
See 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/changes

Changes:

[hashutosh] HIVE-3648 : HiveMetaStoreFsImpl is not compatible with hadoop 
viewfs (Arup Malakar via Ashutosh Chauhan)

[hashutosh] HIVE-3645 : RCFileWriter does not implement the right function to 
support Federation (Arup Malakar via Ashutosh Chauhan)

--
[...truncated 9857 lines...]
 [echo] Project: serde
[javac] Compiling 26 source files to 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/serde/test/classes
[javac] Note: Some input files use or override a deprecated API.
[javac] Note: Recompile with -Xlint:deprecation for details.
[javac] Note: Some input files use unchecked or unsafe operations.
[javac] Note: Recompile with -Xlint:unchecked for details.

create-dirs:
 [echo] Project: service
 [copy] Warning: 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/service/src/test/resources
 does not exist.

init:
 [echo] Project: service

ivy-init-settings:
 [echo] Project: service

ivy-resolve:
 [echo] Project: service
[ivy:resolve] :: loading settings :: file = 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/ivy/ivysettings.xml
[ivy:report] Processing 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/ivy/resolution-cache/org.apache.hive-hive-service-default.xml
 to 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/ivy/report/org.apache.hive-hive-service-default.html

ivy-retrieve:
 [echo] Project: service

compile:
 [echo] Project: service

ivy-resolve-test:
 [echo] Project: service

ivy-retrieve-test:
 [echo] Project: service

compile-test:
 [echo] Project: service
[javac] Compiling 2 source files to 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/service/test/classes

test:
 [echo] Project: hive

test-shims:
 [echo] Project: hive

test-conditions:
 [echo] Project: shims

gen-test:
 [echo] Project: shims

create-dirs:
 [echo] Project: shims
 [copy] Warning: 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/shims/src/test/resources
 does not exist.

init:
 [echo] Project: shims

ivy-init-settings:
 [echo] Project: shims

ivy-resolve:
 [echo] Project: shims
[ivy:resolve] :: loading settings :: file = 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/ivy/ivysettings.xml
[ivy:report] Processing 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/ivy/resolution-cache/org.apache.hive-hive-shims-default.xml
 to 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/ivy/report/org.apache.hive-hive-shims-default.html

ivy-retrieve:
 [echo] Project: shims

compile:
 [echo] Project: shims
 [echo] Building shims 0.20

build_shims:
 [echo] Project: shims
 [echo] Compiling 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/shims/src/common/java;/home/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/0.20/java
 against hadoop 0.20.2 
(https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/hadoopcore/hadoop-0.20.2)

ivy-init-settings:
 [echo] Project: shims

ivy-resolve-hadoop-shim:
 [echo] Project: shims
[ivy:resolve] :: loading settings :: file = 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/ivy/ivysettings.xml

ivy-retrieve-hadoop-shim:
 [echo] Project: shims
 [echo] Building shims 0.20S

build_shims:
 [echo] Project: shims
 [echo] Compiling 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/shims/src/common/java;/home/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/common-secure/java;/home/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/0.20S/java
 against hadoop 1.0.0 
(https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/219/artifact/hive/build/hadoopcore/hadoop-1.0.0)

ivy-init-settings:
 [echo] Project: shims

ivy-resolve-hadoop-shim:
 [echo] Project: shims
[ivy:resolve] :: loading settings :: file = 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/ivy/ivysettings.xml

ivy-retrieve-hadoop-shim:
 [echo] Project: shims
 [echo] Building shims 0.23

build_shims:
 [echo] Project: shims
 [echo] Compiling 

[jira] [Updated] (HIVE-3400) Add Retries to Hive MetaStore Connections

2012-12-05 Thread Bhushan Mandhani (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bhushan Mandhani updated HIVE-3400:
---

Attachment: HIVE-3400.3.patch.txt

 Add Retries to Hive MetaStore Connections
 -

 Key: HIVE-3400
 URL: https://issues.apache.org/jira/browse/HIVE-3400
 Project: Hive
  Issue Type: Improvement
  Components: Metastore
Reporter: Bhushan Mandhani
Assignee: Bhushan Mandhani
Priority: Minor
  Labels: metastore
 Attachments: HIVE-3400.1.patch.txt, HIVE-3400.2.patch.txt, 
 HIVE-3400.3.patch.txt


 Currently, when using Thrift to access the MetaStore, if the Thrift host 
 dies, there is no mechanism to reconnect to some other host even if the 
 MetaStore URIs variable in the Conf contains multiple hosts. Hive should 
 retry and reconnect rather than throwing a communication link error.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-2477) Use name of original expression for name of CAST output

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-2477:
-

Status: Open  (was: Patch Available)

minor comments on phabricator

 Use name of original expression for name of CAST output
 ---

 Key: HIVE-2477
 URL: https://issues.apache.org/jira/browse/HIVE-2477
 Project: Hive
  Issue Type: Improvement
Reporter: Adam Kramer
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2477.1.patch.txt, HIVE-2477.D7161.1.patch


 CAST(foo AS INT)
 should, by default, consider itself a column named foo if 
 unspecified/unaliased.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-2477) Use name of original expression for name of CAST output

2012-12-05 Thread Phabricator (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511082#comment-13511082
 ] 

Phabricator commented on HIVE-2477:
---

njain has commented on the revision HIVE-2477 [jira] Use name of original 
expression for name of CAST output.

  minor comments

INLINE COMMENTS
  ql/src/test/queries/clientpositive/alias_casted_column.q:1 you forgot to add 
the output file for this
  ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java:1185 do you 
want to add a indirection ?

  something like:

  isOpPreserveInputName() -- which can call isOpCast (isOpCast can be private).
  and the caller (SemanticAnalyzer can call isOpPreserveName). If in future 
there
  is another function with this requirement, it would be easy.

REVISION DETAIL
  https://reviews.facebook.net/D7161

To: JIRA, navis
Cc: njain


 Use name of original expression for name of CAST output
 ---

 Key: HIVE-2477
 URL: https://issues.apache.org/jira/browse/HIVE-2477
 Project: Hive
  Issue Type: Improvement
Reporter: Adam Kramer
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2477.1.patch.txt, HIVE-2477.D7161.1.patch


 CAST(foo AS INT)
 should, by default, consider itself a column named foo if 
 unspecified/unaliased.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3594) When Group by Partition Column Type is Timestamp or STRING Which Format contains HH:MM:SS, It will occur URISyntaxException

2012-12-05 Thread Namit Jain (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511084#comment-13511084
 ] 

Namit Jain commented on HIVE-3594:
--

+1

 When Group by Partition Column Type is Timestamp or STRING Which Format 
 contains HH:MM:SS, It will occur URISyntaxException
 -

 Key: HIVE-3594
 URL: https://issues.apache.org/jira/browse/HIVE-3594
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Daisy.Yuan
Assignee: Navis
 Attachments: HIVE-3594.D6081.1.patch, HIVE-3594.D6081.2.patch


 create table test (no int, name string) partitioned by (pts string) row 
 format delimited fields terminated by ' '; 
 load data local inpath '/opt/files/groupbyts1.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts2.txt' into table test 
 partition(pts='21:25:12');
 load data local inpath '/opt/files/groupbyts3.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts4.txt' into table test 
 partition(pts='21:25:12');
 when I execute “select * from test group by pts;”, it will occur as follows 
 exception.
  at org.apache.hadoop.fs.Path.initialize(Path.java:157)
 at org.apache.hadoop.fs.Path.init(Path.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.Utilities.getInputSummary(Utilities.java:1667)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfReducers(MapRedTask.java:432)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.setNumberOfReducers(MapRedTask.java:400)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:93)
 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1329)
 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1121)
 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:954)
 at 
 org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:198)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:630)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:618)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
 at 
 org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 at java.lang.Thread.run(Thread.java:662)
 Caused by: java.net.URISyntaxException: Relative path in absolute URI: 
 fake-path-metadata-only-query-default.test{pts=12:11:30%7D
 at java.net.URI.checkPath(URI.java:1788)
 at java.net.URI.init(URI.java:734)
 at org.apache.hadoop.fs.Path.initialize(Path.java:154)
 ... 19 more
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.MapRedTask
 When PhysicalOptimizer optimizes GroupByOperator, according to default 
 parameters hive.optimize.metadataonly = true, MetadataOnlyOptimizer will be 
 enabled. The MetadataOnlyOptimizer will change the partition alias desc. The 
 partition alies hdfs://ip:9000/user/hive/warehouse/test/pts=12%3A11%3A30 is 
 changed into  
 fake-path-metadata-only-query-default.test{pts=12:11:30}. When construct uri 
 through new partition alies, it must occur java.net.URISyntaxException. 
  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3594) When Group by Partition Column Type is Timestamp or STRING Which Format contains HH:MM:SS, It will occur URISyntaxException

2012-12-05 Thread Phabricator (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511096#comment-13511096
 ] 

Phabricator commented on HIVE-3594:
---

njain has accepted the revision HIVE-3594 [jira] When Group by Partition 
Column Type is Timestamp or STRING Which Format contains HH:MM:SS, It will 
occur URISyntaxException.

REVISION DETAIL
  https://reviews.facebook.net/D6081

BRANCH
  DPAL-1917

To: JIRA, njain, navis


 When Group by Partition Column Type is Timestamp or STRING Which Format 
 contains HH:MM:SS, It will occur URISyntaxException
 -

 Key: HIVE-3594
 URL: https://issues.apache.org/jira/browse/HIVE-3594
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Daisy.Yuan
Assignee: Navis
 Attachments: HIVE-3594.D6081.1.patch, HIVE-3594.D6081.2.patch


 create table test (no int, name string) partitioned by (pts string) row 
 format delimited fields terminated by ' '; 
 load data local inpath '/opt/files/groupbyts1.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts2.txt' into table test 
 partition(pts='21:25:12');
 load data local inpath '/opt/files/groupbyts3.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts4.txt' into table test 
 partition(pts='21:25:12');
 when I execute “select * from test group by pts;”, it will occur as follows 
 exception.
  at org.apache.hadoop.fs.Path.initialize(Path.java:157)
 at org.apache.hadoop.fs.Path.init(Path.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.Utilities.getInputSummary(Utilities.java:1667)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfReducers(MapRedTask.java:432)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.setNumberOfReducers(MapRedTask.java:400)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:93)
 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1329)
 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1121)
 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:954)
 at 
 org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:198)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:630)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:618)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
 at 
 org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 at java.lang.Thread.run(Thread.java:662)
 Caused by: java.net.URISyntaxException: Relative path in absolute URI: 
 fake-path-metadata-only-query-default.test{pts=12:11:30%7D
 at java.net.URI.checkPath(URI.java:1788)
 at java.net.URI.init(URI.java:734)
 at org.apache.hadoop.fs.Path.initialize(Path.java:154)
 ... 19 more
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.MapRedTask
 When PhysicalOptimizer optimizes GroupByOperator, according to default 
 parameters hive.optimize.metadataonly = true, MetadataOnlyOptimizer will be 
 enabled. The MetadataOnlyOptimizer will change the partition alias desc. The 
 partition alies hdfs://ip:9000/user/hive/warehouse/test/pts=12%3A11%3A30 is 
 changed into  
 fake-path-metadata-only-query-default.test{pts=12:11:30}. When construct uri 
 through new partition alies, it must occur java.net.URISyntaxException. 
  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3401) Diversify grammar for split sampling

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3401:
-

Status: Open  (was: Patch Available)

Can you refresh ? This patch is not applying cleanly

 Diversify grammar for split sampling
 

 Key: HIVE-3401
 URL: https://issues.apache.org/jira/browse/HIVE-3401
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
Reporter: Navis
Assignee: Navis
Priority: Trivial
 Attachments: HIVE-3401.D4821.2.patch


 Current split sampling only supports grammar like TABLESAMPLE(n PERCENT). But 
 some users wants to specify just the size of input. It can be easily 
 calculated with a few commands but it seemed good to support more grammars 
 something like TABLESAMPLE(500M). 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-2723) should throw Ambiguous column reference key Exception in particular join condition

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-2723:
-

Attachment: hive.2723.1.patch

 should throw  Ambiguous column reference key  Exception in particular join 
 condition
 --

 Key: HIVE-2723
 URL: https://issues.apache.org/jira/browse/HIVE-2723
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
 Environment: Linux zongren-VirtualBox 3.0.0-14-generic #23-Ubuntu SMP 
 Mon Nov 21 20:34:47 UTC 2011 i686 i686 i386 GNU/Linux
 java version 1.6.0_25
 hadoop-0.20.2-cdh3u0
 hive-0.7.0-cdh3u0
Reporter: caofangkun
Assignee: Navis
Priority: Minor
  Labels: exception-handling, query, queryparser
 Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, 
 ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch, 
 HIVE-2723.D1275.3.patch


  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-2723) should throw Ambiguous column reference key Exception in particular join condition

2012-12-05 Thread Namit Jain (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511099#comment-13511099
 ] 

Namit Jain commented on HIVE-2723:
--

+1

Looks good. running tests

 should throw  Ambiguous column reference key  Exception in particular join 
 condition
 --

 Key: HIVE-2723
 URL: https://issues.apache.org/jira/browse/HIVE-2723
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
 Environment: Linux zongren-VirtualBox 3.0.0-14-generic #23-Ubuntu SMP 
 Mon Nov 21 20:34:47 UTC 2011 i686 i686 i386 GNU/Linux
 java version 1.6.0_25
 hadoop-0.20.2-cdh3u0
 hive-0.7.0-cdh3u0
Reporter: caofangkun
Assignee: Navis
Priority: Minor
  Labels: exception-handling, query, queryparser
 Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, 
 ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch, 
 HIVE-2723.D1275.3.patch


  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3140:
-

Assignee: (was: Zhenxiao Luo)
  Status: Open  (was: Patch Available)

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Assigned] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain reassigned HIVE-3140:


Assignee: Zhenxiao Luo

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
Assignee: Zhenxiao Luo
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Namit Jain (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511100#comment-13511100
 ] 

Namit Jain commented on HIVE-3140:
--

[~zhenxiao], can you submit a new patch at reviews.facebook.net (I mean, not a 
internal fb review, but a external review).

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
Assignee: Zhenxiao Luo
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Zhenxiao Luo (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511101#comment-13511101
 ] 

Zhenxiao Luo commented on HIVE-3140:


[~namit], A review request is submitted at:
https://reviews.facebook.net/D7173

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
Assignee: Zhenxiao Luo
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Zhenxiao Luo (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhenxiao Luo updated HIVE-3140:
---

Status: Patch Available  (was: Open)

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
Assignee: Zhenxiao Luo
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3766) Enable adding hooks to hive meta store init

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3766:
-

Status: Open  (was: Patch Available)

minor comments on phabricator

 Enable adding hooks to hive meta store init
 ---

 Key: HIVE-3766
 URL: https://issues.apache.org/jira/browse/HIVE-3766
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Reporter: Jean Xu
Assignee: Jean Xu

 We will enable hooks to be added to init HMSHandler

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3762) Minor fix for 'tableName' in Hive.g

2012-12-05 Thread Namit Jain (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511103#comment-13511103
 ] 

Namit Jain commented on HIVE-3762:
--

+1

 Minor fix for 'tableName' in Hive.g
 ---

 Key: HIVE-3762
 URL: https://issues.apache.org/jira/browse/HIVE-3762
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
Reporter: Navis
Assignee: Navis
Priority: Trivial
 Attachments: HIVE-3762.D7143.1.patch


 Current definition for 'tableName' is (db=Identifier DOT)? tab=Identifier. 
 If user specifies value default. for it, hive parser accepts default as 
 table name and reserves . for next token but it's not valid.
 Really trivial but it is small needed part for improving query 
 auto-completion (I'm doing it).

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3762) Minor fix for 'tableName' in Hive.g

2012-12-05 Thread Phabricator (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511104#comment-13511104
 ] 

Phabricator commented on HIVE-3762:
---

njain has accepted the revision HIVE-3762 [jira] Minor fix for 'tableName' in 
Hive.g.

REVISION DETAIL
  https://reviews.facebook.net/D7143

BRANCH
  DPAL-1939

To: JIRA, njain, navis


 Minor fix for 'tableName' in Hive.g
 ---

 Key: HIVE-3762
 URL: https://issues.apache.org/jira/browse/HIVE-3762
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
Reporter: Navis
Assignee: Navis
Priority: Trivial
 Attachments: HIVE-3762.D7143.1.patch


 Current definition for 'tableName' is (db=Identifier DOT)? tab=Identifier. 
 If user specifies value default. for it, hive parser accepts default as 
 table name and reserves . for next token but it's not valid.
 Really trivial but it is small needed part for improving query 
 auto-completion (I'm doing it).

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3140) Comment indenting is broken for describe in CLI

2012-12-05 Thread Namit Jain (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511105#comment-13511105
 ] 

Namit Jain commented on HIVE-3140:
--

I will take a look

 Comment indenting is broken for describe in CLI
 -

 Key: HIVE-3140
 URL: https://issues.apache.org/jira/browse/HIVE-3140
 Project: Hive
  Issue Type: Bug
  Components: CLI
Reporter: Xiaoxiao Hou
Assignee: Zhenxiao Luo
  Labels: patch
 Fix For: 0.10.0

 Attachments: HIVE-3140.1.patch.txt

   Original Estimate: 72h
  Remaining Estimate: 72h

 Just go into the CLI and type describe [TABLE_NAME]. If a comment has 
 multiple lines, it is completely unreadable due to poor comment indenting. 
 For example:
 birthdayParam string 1 = comment1
 2 = comment2
 3 = comment3
 But it supposed to display as:
 birthdayParam string 1 = comment1
  2 = comment2
  3 = comment3
 Comments should be indented the same amount on each line, i.e., if the 
 comment starts at row k for the first line of the comment, it should be 
 indented by k on line 2.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Created] (HIVE-3774) Sort merge join should work if join cols are a prefix of sort columns for each partition

2012-12-05 Thread Namit Jain (JIRA)
Namit Jain created HIVE-3774:


 Summary: Sort merge join should work if join cols are a prefix of 
sort columns for each partition
 Key: HIVE-3774
 URL: https://issues.apache.org/jira/browse/HIVE-3774
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Namit Jain
Assignee: Namit Jain


Currently, a join is converted into a sort-merge join only if the join cols 
exactly matches the sort cols.
This constraint can definitely be relaxed.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3464) Merging join tree may reorder joins which could be invalid

2012-12-05 Thread Phabricator (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-3464:
--

Attachment: HIVE-3464.D5409.3.patch

navis updated the revision HIVE-3464 [jira] Merging join tree may reorder 
joins which could be invalid.
Reviewers: JIRA

  Fixed test result of recently added tests
  Added comments, rebased on trunk


REVISION DETAIL
  https://reviews.facebook.net/D5409

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/test/queries/clientpositive/mergejoins_mixed.q
  ql/src/test/results/clientpositive/join_filters_overlap.q.out
  ql/src/test/results/clientpositive/mergejoins_mixed.q.out

To: JIRA, navis


 Merging join tree may reorder joins which could be invalid
 --

 Key: HIVE-3464
 URL: https://issues.apache.org/jira/browse/HIVE-3464
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 0.10.0
Reporter: Navis
Assignee: Navis
 Attachments: HIVE-3464.D5409.2.patch, HIVE-3464.D5409.3.patch


 Currently, hive merges join tree from right to left regardless of join types, 
 which may introduce join reordering. For example,
 select * from a join a b on a.key=b.key join a c on b.key=c.key join a d on 
 a.key=d.key; 
 Hive tries to merge join tree in a-d=b-d, a-d=a-b, b-c=a-b order and a-d=a-b 
 and b-c=a-b will be merged. Final join tree is a-(bdc).
 With this, ab-d join will be executed prior to ab-c. But if join type of -c 
 and -d is different, this is not valid.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3594) When Group by Partition Column Type is Timestamp or STRING Which Format contains HH:MM:SS, It will occur URISyntaxException

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3594:
-

  Resolution: Fixed
Hadoop Flags: Reviewed
  Status: Resolved  (was: Patch Available)

Committed. Thanks Navis

 When Group by Partition Column Type is Timestamp or STRING Which Format 
 contains HH:MM:SS, It will occur URISyntaxException
 -

 Key: HIVE-3594
 URL: https://issues.apache.org/jira/browse/HIVE-3594
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Daisy.Yuan
Assignee: Navis
 Attachments: HIVE-3594.D6081.1.patch, HIVE-3594.D6081.2.patch


 create table test (no int, name string) partitioned by (pts string) row 
 format delimited fields terminated by ' '; 
 load data local inpath '/opt/files/groupbyts1.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts2.txt' into table test 
 partition(pts='21:25:12');
 load data local inpath '/opt/files/groupbyts3.txt' into table test 
 partition(pts='12:11:30');
 load data local inpath '/opt/files/groupbyts4.txt' into table test 
 partition(pts='21:25:12');
 when I execute “select * from test group by pts;”, it will occur as follows 
 exception.
  at org.apache.hadoop.fs.Path.initialize(Path.java:157)
 at org.apache.hadoop.fs.Path.init(Path.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.Utilities.getInputSummary(Utilities.java:1667)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfReducers(MapRedTask.java:432)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.setNumberOfReducers(MapRedTask.java:400)
 at 
 org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:93)
 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
 at 
 org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1329)
 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1121)
 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:954)
 at 
 org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:198)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:630)
 at 
 org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:618)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
 at 
 org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 at java.lang.Thread.run(Thread.java:662)
 Caused by: java.net.URISyntaxException: Relative path in absolute URI: 
 fake-path-metadata-only-query-default.test{pts=12:11:30%7D
 at java.net.URI.checkPath(URI.java:1788)
 at java.net.URI.init(URI.java:734)
 at org.apache.hadoop.fs.Path.initialize(Path.java:154)
 ... 19 more
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.MapRedTask
 When PhysicalOptimizer optimizes GroupByOperator, according to default 
 parameters hive.optimize.metadataonly = true, MetadataOnlyOptimizer will be 
 enabled. The MetadataOnlyOptimizer will change the partition alias desc. The 
 partition alies hdfs://ip:9000/user/hive/warehouse/test/pts=12%3A11%3A30 is 
 changed into  
 fake-path-metadata-only-query-default.test{pts=12:11:30}. When construct uri 
 through new partition alies, it must occur java.net.URISyntaxException. 
  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-2723) should throw Ambiguous column reference key Exception in particular join condition

2012-12-05 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-2723:
-

  Resolution: Fixed
Hadoop Flags: Reviewed
  Status: Resolved  (was: Patch Available)

Committed. Thanks Navis

 should throw  Ambiguous column reference key  Exception in particular join 
 condition
 --

 Key: HIVE-2723
 URL: https://issues.apache.org/jira/browse/HIVE-2723
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
 Environment: Linux zongren-VirtualBox 3.0.0-14-generic #23-Ubuntu SMP 
 Mon Nov 21 20:34:47 UTC 2011 i686 i686 i386 GNU/Linux
 java version 1.6.0_25
 hadoop-0.20.2-cdh3u0
 hive-0.7.0-cdh3u0
Reporter: caofangkun
Assignee: Navis
Priority: Minor
  Labels: exception-handling, query, queryparser
 Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, 
 ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch, 
 HIVE-2723.D1275.3.patch


  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3401) Diversify grammar for split sampling

2012-12-05 Thread Navis (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Navis updated HIVE-3401:


Status: Patch Available  (was: Open)

 Diversify grammar for split sampling
 

 Key: HIVE-3401
 URL: https://issues.apache.org/jira/browse/HIVE-3401
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
Reporter: Navis
Assignee: Navis
Priority: Trivial
 Attachments: HIVE-3401.D4821.2.patch, HIVE-3401.D4821.3.patch


 Current split sampling only supports grammar like TABLESAMPLE(n PERCENT). But 
 some users wants to specify just the size of input. It can be easily 
 calculated with a few commands but it seemed good to support more grammars 
 something like TABLESAMPLE(500M). 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3401) Diversify grammar for split sampling

2012-12-05 Thread Phabricator (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-3401:
--

Attachment: HIVE-3401.D4821.3.patch

navis updated the revision HIVE-3401 [jira] Diversify grammar for split 
sampling.
Reviewers: JIRA

  Fixed test results, rebased on trunk


REVISION DETAIL
  https://reviews.facebook.net/D4821

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/FetchOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/MapRedTask.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/TableScanOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/io/CombineHiveInputFormat.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/ParseDriver.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SplitSample.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/TableScanDesc.java
  ql/src/test/queries/clientpositive/split_sample.q
  ql/src/test/results/clientpositive/input4.q.out
  ql/src/test/results/clientpositive/nonmr_fetch.q.out
  ql/src/test/results/clientpositive/plan_json.q.out
  ql/src/test/results/clientpositive/split_sample.q.out

To: JIRA, navis


 Diversify grammar for split sampling
 

 Key: HIVE-3401
 URL: https://issues.apache.org/jira/browse/HIVE-3401
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
Reporter: Navis
Assignee: Navis
Priority: Trivial
 Attachments: HIVE-3401.D4821.2.patch, HIVE-3401.D4821.3.patch


 Current split sampling only supports grammar like TABLESAMPLE(n PERCENT). But 
 some users wants to specify just the size of input. It can be easily 
 calculated with a few commands but it seemed good to support more grammars 
 something like TABLESAMPLE(500M). 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-2477) Use name of original expression for name of CAST output

2012-12-05 Thread Phabricator (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511192#comment-13511192
 ] 

Phabricator commented on HIVE-2477:
---

navis has commented on the revision HIVE-2477 [jira] Use name of original 
expression for name of CAST output.

INLINE COMMENTS
  ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java:1185 Seemed 
reasonable. I'll do that.
  ql/src/test/queries/clientpositive/alias_casted_column.q:1 Sorry

REVISION DETAIL
  https://reviews.facebook.net/D7161

To: JIRA, navis
Cc: njain


 Use name of original expression for name of CAST output
 ---

 Key: HIVE-2477
 URL: https://issues.apache.org/jira/browse/HIVE-2477
 Project: Hive
  Issue Type: Improvement
Reporter: Adam Kramer
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2477.1.patch.txt, HIVE-2477.D7161.1.patch


 CAST(foo AS INT)
 should, by default, consider itself a column named foo if 
 unspecified/unaliased.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3645) RCFileWriter does not implement the right function to support Federation

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511199#comment-13511199
 ] 

Hudson commented on HIVE-3645:
--

Integrated in Hive-0.9.1-SNAPSHOT-h0.21 #219 (See 
[https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/219/])
HIVE-3645 : RCFileWriter does not implement the right function to support 
Federation (Arup Malakar via Ashutosh Chauhan) (Revision 1417220)

 Result = FAILURE
hashutosh : 
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417220
Files : 
* /hive/branches/branch-0.9/ql/src/java/org/apache/hadoop/hive/ql/io/RCFile.java
* 
/hive/branches/branch-0.9/shims/src/0.20/java/org/apache/hadoop/hive/shims/Hadoop20Shims.java
* 
/hive/branches/branch-0.9/shims/src/0.20S/java/org/apache/hadoop/hive/shims/Hadoop20SShims.java
* 
/hive/branches/branch-0.9/shims/src/0.23/java/org/apache/hadoop/hive/shims/Hadoop23Shims.java
* 
/hive/branches/branch-0.9/shims/src/common-secure/java/org/apache/hadoop/hive/shims/HadoopShimsSecure.java
* 
/hive/branches/branch-0.9/shims/src/common/java/org/apache/hadoop/hive/shims/HadoopShims.java


 RCFileWriter does not implement the right function to support Federation
 

 Key: HIVE-3645
 URL: https://issues.apache.org/jira/browse/HIVE-3645
 Project: Hive
  Issue Type: Bug
  Components: Serializers/Deserializers
Affects Versions: 0.9.0, 0.10.0
 Environment: Hadoop 0.23.3 federation, Hive 0.9 and Pig 0.10
Reporter: Viraj Bhat
Assignee: Arup Malakar
 Fix For: 0.11

 Attachments: HIVE_3645_branch_0.patch, HIVE_3645_trunk_0.patch


 Create a table using Hive DDL
 {code}
 CREATE TABLE tmp_hcat_federated_numbers_part_1 (
   id   int,  
   intnum   int,
   floatnum float
 )partitioned by (
   part1string,
   part2string
 )
 STORED AS rcfile
 LOCATION 'viewfs:///database/tmp_hcat_federated_numbers_part_1';
 {code}
 Populate it using Pig:
 {code}
 A = load 'default.numbers_pig' using org.apache.hcatalog.pig.HCatLoader();
 B = filter A by id =  500;
 C = foreach B generate (int)id, (int)intnum, (float)floatnum;
 store C into
 'default.tmp_hcat_federated_numbers_part_1'
 using org.apache.hcatalog.pig.HCatStorer
('part1=pig, part2=hcat_pig_insert',
 'id: int,intnum: int,floatnum: float');
 {code}
 Generates the following error when running on a Federated Cluster:
 {quote}
 2012-10-29 20:40:25,011 [main] ERROR
 org.apache.pig.tools.pigstats.SimplePigStats - ERROR 2997: Unable to recreate
 exception from backed error: AttemptID:attempt_1348522594824_0846_m_00_3
 Info:Error: org.apache.hadoop.fs.viewfs.NotInMountpointException:
 getDefaultReplication on empty path is invalid
 at
 org.apache.hadoop.fs.viewfs.ViewFileSystem.getDefaultReplication(ViewFileSystem.java:479)
 at org.apache.hadoop.hive.ql.io.RCFile$Writer.init(RCFile.java:723)
 at org.apache.hadoop.hive.ql.io.RCFile$Writer.init(RCFile.java:705)
 at
 org.apache.hadoop.hive.ql.io.RCFileOutputFormat.getRecordWriter(RCFileOutputFormat.java:86)
 at
 org.apache.hcatalog.mapreduce.FileOutputFormatContainer.getRecordWriter(FileOutputFormatContainer.java:100)
 at
 org.apache.hcatalog.mapreduce.HCatOutputFormat.getRecordWriter(HCatOutputFormat.java:228)
 at
 org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.PigOutputFormat.getRecordWriter(PigOutputFormat.java:84)
 at
 org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.init(MapTask.java:587)
 at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:706)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
 at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:157)
 at java.security.AccessController.doPrivileged(Native Method)
 at javax.security.auth.Subject.doAs(Subject.java:396)
 at
 org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1212)
 at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:152)
 {quote}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3648) HiveMetaStoreFsImpl is not compatible with hadoop viewfs

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511198#comment-13511198
 ] 

Hudson commented on HIVE-3648:
--

Integrated in Hive-0.9.1-SNAPSHOT-h0.21 #219 (See 
[https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/219/])
HIVE-3648 : HiveMetaStoreFsImpl is not compatible with hadoop viewfs (Arup 
Malakar via Ashutosh Chauhan) (Revision 1417267)

 Result = FAILURE
hashutosh : 
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417267
Files : 
* 
/hive/branches/branch-0.9/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStoreFsImpl.java
* 
/hive/branches/branch-0.9/shims/src/0.20/java/org/apache/hadoop/hive/shims/Hadoop20Shims.java
* 
/hive/branches/branch-0.9/shims/src/0.20S/java/org/apache/hadoop/hive/shims/Hadoop20SShims.java
* 
/hive/branches/branch-0.9/shims/src/0.23/java/org/apache/hadoop/hive/shims/Hadoop23Shims.java
* 
/hive/branches/branch-0.9/shims/src/common-secure/java/org/apache/hadoop/hive/shims/HadoopShimsSecure.java
* 
/hive/branches/branch-0.9/shims/src/common/java/org/apache/hadoop/hive/shims/HadoopShims.java


 HiveMetaStoreFsImpl is not compatible with hadoop viewfs
 

 Key: HIVE-3648
 URL: https://issues.apache.org/jira/browse/HIVE-3648
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 0.9.0, 0.10.0
Reporter: Kihwal Lee
Assignee: Arup Malakar
 Fix For: 0.11

 Attachments: HIVE_3648_branch_0.patch, HIVE_3648_branch_1.patch, 
 HIVE-3648-trunk-0.patch, HIVE_3648_trunk_1.patch, HIVE-3648-trunk-1.patch


 HiveMetaStoreFsImpl#deleteDir() method calls Trash#moveToTrash(). This may 
 not work when viewfs is used. It needs to call Trash#moveToAppropriateTrash() 
 instead.  Please note that this method is not available in hadoop versions 
 earlier than 0.23.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


Build failed in Jenkins: Hive-0.9.1-SNAPSHOT-h0.21 #219

2012-12-05 Thread Apache Jenkins Server
See https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/219/changes

Changes:

[hashutosh] HIVE-3648 : HiveMetaStoreFsImpl is not compatible with hadoop 
viewfs (Arup Malakar via Ashutosh Chauhan)

[hashutosh] HIVE-3645 : RCFileWriter does not implement the right function to 
support Federation (Arup Malakar via Ashutosh Chauhan)

--
[...truncated 36517 lines...]
[junit] OK
[junit] PREHOOK: query: drop table testhivedrivertable
[junit] PREHOOK: type: DROPTABLE
[junit] PREHOOK: Input: default@testhivedrivertable
[junit] PREHOOK: Output: default@testhivedrivertable
[junit] POSTHOOK: query: drop table testhivedrivertable
[junit] POSTHOOK: type: DROPTABLE
[junit] POSTHOOK: Input: default@testhivedrivertable
[junit] POSTHOOK: Output: default@testhivedrivertable
[junit] OK
[junit] Hive history 
file=https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/219/artifact/hive/build/service/tmp/hive_job_log_jenkins_201212052336_2029219152.txt
[junit] PREHOOK: query: drop table testhivedrivertable
[junit] PREHOOK: type: DROPTABLE
[junit] POSTHOOK: query: drop table testhivedrivertable
[junit] POSTHOOK: type: DROPTABLE
[junit] OK
[junit] PREHOOK: query: create table testhivedrivertable (num int)
[junit] PREHOOK: type: DROPTABLE
[junit] Copying file: 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/ws/hive/data/files/kv1.txt
[junit] POSTHOOK: query: create table testhivedrivertable (num int)
[junit] POSTHOOK: type: DROPTABLE
[junit] POSTHOOK: Output: default@testhivedrivertable
[junit] OK
[junit] PREHOOK: query: load data local inpath 
'https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/ws/hive/data/files/kv1.txt'
 into table testhivedrivertable
[junit] PREHOOK: type: DROPTABLE
[junit] PREHOOK: Output: default@testhivedrivertable
[junit] Copying data from 
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/ws/hive/data/files/kv1.txt
[junit] Loading data to table default.testhivedrivertable
[junit] POSTHOOK: query: load data local inpath 
'https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/ws/hive/data/files/kv1.txt'
 into table testhivedrivertable
[junit] POSTHOOK: type: DROPTABLE
[junit] POSTHOOK: Output: default@testhivedrivertable
[junit] OK
[junit] PREHOOK: query: select * from testhivedrivertable limit 10
[junit] PREHOOK: type: DROPTABLE
[junit] PREHOOK: Input: default@testhivedrivertable
[junit] PREHOOK: Output: 
file:/tmp/jenkins/hive_2012-12-05_23-36-46_559_2289121912146588092/-mr-1
[junit] POSTHOOK: query: select * from testhivedrivertable limit 10
[junit] POSTHOOK: type: DROPTABLE
[junit] POSTHOOK: Input: default@testhivedrivertable
[junit] POSTHOOK: Output: 
file:/tmp/jenkins/hive_2012-12-05_23-36-46_559_2289121912146588092/-mr-1
[junit] OK
[junit] PREHOOK: query: drop table testhivedrivertable
[junit] PREHOOK: type: DROPTABLE
[junit] PREHOOK: Input: default@testhivedrivertable
[junit] PREHOOK: Output: default@testhivedrivertable
[junit] POSTHOOK: query: drop table testhivedrivertable
[junit] POSTHOOK: type: DROPTABLE
[junit] POSTHOOK: Input: default@testhivedrivertable
[junit] POSTHOOK: Output: default@testhivedrivertable
[junit] OK
[junit] Hive history 
file=https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/219/artifact/hive/build/service/tmp/hive_job_log_jenkins_201212052336_870706041.txt
[junit] PREHOOK: query: drop table testhivedrivertable
[junit] PREHOOK: type: DROPTABLE
[junit] POSTHOOK: query: drop table testhivedrivertable
[junit] POSTHOOK: type: DROPTABLE
[junit] OK
[junit] PREHOOK: query: create table testhivedrivertable (num int)
[junit] PREHOOK: type: DROPTABLE
[junit] POSTHOOK: query: create table testhivedrivertable (num int)
[junit] POSTHOOK: type: DROPTABLE
[junit] POSTHOOK: Output: default@testhivedrivertable
[junit] OK
[junit] PREHOOK: query: drop table testhivedrivertable
[junit] PREHOOK: type: DROPTABLE
[junit] PREHOOK: Input: default@testhivedrivertable
[junit] PREHOOK: Output: default@testhivedrivertable
[junit] POSTHOOK: query: drop table testhivedrivertable
[junit] POSTHOOK: type: DROPTABLE
[junit] POSTHOOK: Input: default@testhivedrivertable
[junit] POSTHOOK: Output: default@testhivedrivertable
[junit] OK
[junit] Hive history 
file=https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/219/artifact/hive/build/service/tmp/hive_job_log_jenkins_201212052336_1487767884.txt
[junit] Hive history 
file=https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/219/artifact/hive/build/service/tmp/hive_job_log_jenkins_201212052336_677515167.txt
[junit] PREHOOK: query: drop table testhivedrivertable
[junit] PREHOOK: type: DROPTABLE
[junit] POSTHOOK: query: drop table testhivedrivertable
[junit] POSTHOOK: type: 

[jira] [Commented] (HIVE-3384) HIVE JDBC module won't compile under JDK1.7 as new methods added in JDBC specification

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511201#comment-13511201
 ] 

Hudson commented on HIVE-3384:
--

Integrated in Hive-trunk-h0.21 #1835 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1835/])
HIVE-3384 : HIVE JDBC module won't compile under JDK1.7 as new methods 
added in JDBC specification (Shengsheng Huang, Chris Drome, Mikhail Bautin via 
Ashutosh Chauhan) (Revision 1417235)

 Result = FAILURE
hashutosh : 
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417235
Files : 
* /hive/trunk/build-common.xml
* /hive/trunk/build.properties
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveBaseResultSet.java
* 
/hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveCallableStatement.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveConnection.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDataSource.java
* 
/hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDatabaseMetaData.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDriver.java
* 
/hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HivePreparedStatement.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveQueryResultSet.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveStatement.java
* /hive/trunk/metastore/build.xml
* /hive/trunk/pdk/scripts/build-plugin.xml


 HIVE JDBC module won't compile under JDK1.7 as new methods added in JDBC 
 specification
 --

 Key: HIVE-3384
 URL: https://issues.apache.org/jira/browse/HIVE-3384
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Reporter: Weidong Bian
Assignee: Mikhail Bautin
Priority: Minor
 Fix For: 0.11

 Attachments: D6873-0.9.1.patch, D6873.1.patch, D6873.2.patch, 
 D6873.3.patch, D6873.4.patch, D6873.5.patch, D6873.6.patch, D6873.7.patch, 
 HIVE-3384-2012-12-02.patch, HIVE-3384-2012-12-04.patch, HIVE-3384.2.patch, 
 HIVE-3384-branch-0.9.patch, HIVE-3384.patch, HIVE-JDK7-JDBC.patch


 jdbc module couldn't be compiled with jdk7 as it adds some abstract method in 
 the JDBC specification 
 some error info:
  error: HiveCallableStatement is not abstract and does not override abstract
 method TgetObject(String,ClassT) in CallableStatement
 .
 .
 .

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3702) Renaming table changes table location scheme/authority

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511202#comment-13511202
 ] 

Hudson commented on HIVE-3702:
--

Integrated in Hive-trunk-h0.21 #1835 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1835/])
HIVE-3702 Renaming table changes table location scheme/authority
(Kevin Wilfong via namit) (Revision 1416875)

 Result = FAILURE
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1416875
Files : 
* 
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveAlterHandler.java
* 
/hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/hooks/VerifyOutputTableLocationSchemeIsFileHook.java
* /hive/trunk/ql/src/test/queries/clientpositive/rename_table_location.q
* /hive/trunk/ql/src/test/results/clientpositive/rename_table_location.q.out


 Renaming table changes table location scheme/authority
 --

 Key: HIVE-3702
 URL: https://issues.apache.org/jira/browse/HIVE-3702
 Project: Hive
  Issue Type: Bug
  Components: Metastore
Affects Versions: 0.9.0
Reporter: Kevin Wilfong
Assignee: Kevin Wilfong
 Attachments: HIVE-3702.1.patch.txt, HIVE-3702.2.patch.txt


 Renaming a table changes the location of the table to the default location of 
 the database, followed by the table name.  This means that if the default 
 location of the database uses a different scheme/authority, an exception will 
 get thrown attempting to move the data.
 Instead, the table's location should be made the default location of the 
 database followed by the table name, but using the original location's scheme 
 and authority.
 This only applies for managed tables, and there is already a check to ensure 
 the new location doesn't already exist.
 This is analogous to what was done for partitions in HIVE-2875

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3073) Hive List Bucketing - DML support

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511203#comment-13511203
 ] 

Hudson commented on HIVE-3073:
--

Integrated in Hive-trunk-h0.21 #1835 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1835/])
HIVE-3073 Hive List Bucketing - DML support
(Gang Tim Liu via namit) (Revision 1417374)

 Result = FAILURE
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417374
Files : 
* /hive/trunk/common/src/java/org/apache/hadoop/hive/common/FileUtils.java
* /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
* /hive/trunk/conf/hive-default.xml.template
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/MoveTask.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/StatsTask.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/rcfile/merge/BlockMergeTask.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/rcfile/merge/MergeWork.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/rcfile/merge/RCFileMergeMapper.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Partition.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/formatting/MetaDataFormatUtils.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRFileSink1.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/PrunerOperatorFactory.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/listbucketingpruner/ListBucketingPruner.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/listbucketingpruner/ListBucketingPrunerUtils.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/AlterTablePartMergeFilesDesc.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ConditionalResolverMergeFiles.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/FileSinkDesc.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ListBucketingCtx.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/LoadTableDesc.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java
* /hive/trunk/ql/src/test/queries/clientnegative/column_change_skewedcol_type1.q
* /hive/trunk/ql/src/test/queries/clientnegative/column_rename5.q
* 
/hive/trunk/ql/src/test/queries/clientnegative/create_skewed_table_col_name_value_no_mismatch.q
* 
/hive/trunk/ql/src/test/queries/clientnegative/create_skewed_table_dup_col_name.q
* 
/hive/trunk/ql/src/test/queries/clientnegative/create_skewed_table_failure_invalid_col_name.q
* /hive/trunk/ql/src/test/queries/clientnegative/invalid_config1.q
* /hive/trunk/ql/src/test/queries/clientnegative/load_stored_as_dirs.q
* /hive/trunk/ql/src/test/queries/clientpositive/alter_skewed_table.q
* 
/hive/trunk/ql/src/test/queries/clientpositive/create_alter_list_bucketing_table1.q
* /hive/trunk/ql/src/test/queries/clientpositive/create_skewed_table1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_3.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_4.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_5.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_6.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_7.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_8.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_9.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_multiskew_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_multiskew_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_multiskew_3.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_oneskew_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_oneskew_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_query_oneskew_3.q
* /hive/trunk/ql/src/test/results/clientnegative/invalid_config1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
* 

[jira] [Commented] (HIVE-3771) HIVE-3750 broke TestParse

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511205#comment-13511205
 ] 

Hudson commented on HIVE-3771:
--

Integrated in Hive-trunk-h0.21 #1835 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1835/])
HIVE-3771 HIVE-3750 broke TestParse
(Kevin Wilfong via namit) (Revision 1417294)

 Result = FAILURE
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417294
Files : 
* /hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input7.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input9.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input_testsequencefile.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample7.q.xml


 HIVE-3750 broke TestParse
 -

 Key: HIVE-3771
 URL: https://issues.apache.org/jira/browse/HIVE-3771
 Project: Hive
  Issue Type: Bug
  Components: Testing Infrastructure
Affects Versions: 0.11
Reporter: Kevin Wilfong
Assignee: Kevin Wilfong
 Attachments: HIVE-3771.1.patch.txt


 see title

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-3750) JDBCStatsPublisher fails when ID length exceeds length of ID column

2012-12-05 Thread Hudson (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-3750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511204#comment-13511204
 ] 

Hudson commented on HIVE-3750:
--

Integrated in Hive-trunk-h0.21 #1835 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1835/])
HIVE-3771 HIVE-3750 broke TestParse
(Kevin Wilfong via namit) (Revision 1417294)

 Result = FAILURE
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1417294
Files : 
* /hive/trunk/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/groupby1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input7.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input9.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/input_testsequencefile.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/join3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample2.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample3.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample4.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample5.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample6.q.xml
* /hive/trunk/ql/src/test/results/compiler/plan/sample7.q.xml


 JDBCStatsPublisher fails when ID length exceeds length of ID column
 ---

 Key: HIVE-3750
 URL: https://issues.apache.org/jira/browse/HIVE-3750
 Project: Hive
  Issue Type: Bug
  Components: Statistics
Affects Versions: 0.11
Reporter: Kevin Wilfong
Assignee: Kevin Wilfong
 Attachments: HIVE-3750.1.patch.txt


 When the length of the ID field passed to JDBCStatsPublisher exceeds the 
 length of the column in the table (currently 255 characters) stats collection 
 fails.  This causes the entire query to fail when hive.stats.reliable is set 
 to true.
 One way to prevent this would be to calculate a deterministic, very low 
 collision hash of the ID prefix used for aggregation and use that when the 
 length of the ID is too long.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


Hive-trunk-h0.21 - Build # 1835 - Still Failing

2012-12-05 Thread Apache Jenkins Server
Changes for Build #1831
[namit] HIVE-3747 Provide hive operation name for hookContext
(Shreepadma Venugopalan via namit)


Changes for Build #1832

Changes for Build #1833
[namit] HIVE-3750 JDBCStatsPublisher fails when ID length exceeds length of ID 
column
(Kevin Wilfong via namit)


Changes for Build #1835
[namit] HIVE-3073 Hive List Bucketing - DML support
(Gang Tim Liu via namit)

[namit] HIVE-3771 HIVE-3750 broke TestParse
(Kevin Wilfong via namit)

[hashutosh] HIVE-3384 : HIVE JDBC module won't compile under JDK1.7 as new 
methods added in JDBC specification (Shengsheng Huang, Chris Drome, Mikhail 
Bautin via Ashutosh Chauhan)

[namit] HIVE-3702 Renaming table changes table location scheme/authority
(Kevin Wilfong via namit)




2 tests failed.
FAILED:  org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_stats19

Error Message:
Unexpected exception See build/ql/tmp/hive.log, or try ant test ... 
-Dtest.silent=false to get more logs.

Stack Trace:
junit.framework.AssertionFailedError: Unexpected exception
See build/ql/tmp/hive.log, or try ant test ... -Dtest.silent=false to get 
more logs.
at junit.framework.Assert.fail(Assert.java:47)
at 
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_stats19(TestCliDriver.java:41156)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at junit.framework.TestCase.runTest(TestCase.java:168)
at junit.framework.TestCase.runBare(TestCase.java:134)
at junit.framework.TestResult$1.protect(TestResult.java:110)
at junit.framework.TestResult.runProtected(TestResult.java:128)
at junit.framework.TestResult.run(TestResult.java:113)
at junit.framework.TestCase.run(TestCase.java:124)
at junit.framework.TestSuite.runTest(TestSuite.java:232)
at junit.framework.TestSuite.run(TestSuite.java:227)
at 
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:422)
at 
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:931)
at 
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:785)


REGRESSION:  
org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testNegativeCliDriver_minimr_broken_pipe

Error Message:
Unexpected exception See build/ql/tmp/hive.log, or try ant test ... 
-Dtest.silent=false to get more logs.

Stack Trace:
junit.framework.AssertionFailedError: Unexpected exception
See build/ql/tmp/hive.log, or try ant test ... -Dtest.silent=false to get 
more logs.
at junit.framework.Assert.fail(Assert.java:47)
at 
org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testNegativeCliDriver_minimr_broken_pipe(TestNegativeMinimrCliDriver.java:329)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at junit.framework.TestCase.runTest(TestCase.java:168)
at junit.framework.TestCase.runBare(TestCase.java:134)
at junit.framework.TestResult$1.protect(TestResult.java:110)
at junit.framework.TestResult.runProtected(TestResult.java:128)
at junit.framework.TestResult.run(TestResult.java:113)
at junit.framework.TestCase.run(TestCase.java:124)
at junit.framework.TestSuite.runTest(TestSuite.java:232)
at junit.framework.TestSuite.run(TestSuite.java:227)
at 
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:422)
at 
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:931)
at 
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:785)




The Apache Jenkins build system has built Hive-trunk-h0.21 (build #1835)

Status: Still Failing

Check console output at https://builds.apache.org/job/Hive-trunk-h0.21/1835/ to 
view the results.