[jira] [Updated] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Phabricator (Updated) (JIRA)

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

Phabricator updated HIVE-2792:
--

Attachment: HIVE-2792.D1797.1.patch

navis requested code review of HIVE-2792 [jira] SUBSTR(CAST(string AS 
BINARY)) produces unexpected results.
Reviewers: JIRA

  DPAL-848 SUBSTR(CAST(string AS BINARY)) produces unexpected results

TEST PLAN
  EMPTY

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

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/udf/UDFSubstr.java
  ql/src/test/queries/clientpositive/udf_substr.q
  ql/src/test/results/clientpositive/ba_table_udfs.q.out
  ql/src/test/results/clientpositive/udf_substr.q.out

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

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

Tip: use the X-Herald-Rules header to filter Herald messages in your client.


 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Reporter: Carl Steinbach
 Attachments: HIVE-2792.D1797.1.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Phabricator (Commented) (JIRA)

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

Phabricator commented on HIVE-2792:
---

navis has commented on the revision HIVE-2792 [jira] SUBSTR(CAST(string AS 
BINARY)) produces unexpected results.

  For substr() for binary type..
  1. Fixed length problem (dummy values at the end)
  2. Changed to use 1-based index (like mysql)

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


 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Reporter: Carl Steinbach
 Attachments: HIVE-2792.D1797.1.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




check scriptPid in ScriptOperator.java to avoid BrokenPipeException: script_broken_pipe1.q, script_broken_pipe2.q, minimr_broken_pipe.q won't FAILED

2012-02-20 Thread Bing Li
Hi, developers
I found that in ScriptOperator.close(), when it catch an IOException, it
doesn't check the status of the scriptPid, I mean if the process is null.
which may cause a race condition.
I did a change that

In ScriptOperator.close()
try {
  if ( scriptOutWriter != null ) {
scriptOutWriter.close();
  }
} catch (IOException e ) {
  if ( (isBrokenPipeException(e)  allowPartialConsumption()) *||
(scriptPid != null  scriptPid.exitValue() == 0)*) {
   ...
  }


Also the related logic in ScriptOperator.processOp().


After that, I found the following UT cases failed, because got a successful
job instead of a failure:
[junit] Tests run: 332, Failures: 2, Errors: 0, Time elapsed: 836.821
sec
[junit] Test org.apache.hadoop.hive.cli.TestNegativeCliDriver FAILED
script_broken_pipe1.q
script_broken_pipe2.q

[junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 40.389 sec
[junit] Test org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver
FAILED
minimr_broken_pipe.q


Is it acceptable?


Thanks,
- Bing


Hive-0.8.1-SNAPSHOT-h0.21 - Build # 200 - Fixed

2012-02-20 Thread Apache Jenkins Server
Changes for Build #199

Changes for Build #200



All tests passed

The Apache Jenkins build system has built Hive-0.8.1-SNAPSHOT-h0.21 (build #200)

Status: Fixed

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

how can I get the AST in hive?

2012-02-20 Thread Alexis De La Cruz Toledo
Hi I have a doubt, How can I get the AST in Hive?
and how can I get the QB Tree in Hive?

Thank you.
Regards.

-- 
Ing. Alexis de la Cruz Toledo.
*Av. Instituto Politécnico Nacional No. 2508 Col. San Pedro Zacatenco. México,
D.F, 07360 *
*CINVESTAV, DF.*


[jira] [Assigned] (HIVE-2780) Implement more restrictive table sampler

2012-02-20 Thread Navis (Assigned) (JIRA)

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

Navis reassigned HIVE-2780:
---

Assignee: Navis

 Implement more restrictive table sampler
 

 Key: HIVE-2780
 URL: https://issues.apache.org/jira/browse/HIVE-2780
 Project: Hive
  Issue Type: Improvement
Reporter: Navis
Assignee: Navis
Priority: Trivial
 Attachments: HIVE-2780.D1623.1.patch


 Current table sampling scans whole block, making more rows included than 
 expected especially for small tables.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2716) Move retry logic in HiveMetaStore to a separe class

2012-02-20 Thread Phabricator (Commented) (JIRA)

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

Phabricator commented on HIVE-2716:
---

ashutoshc has accepted the revision HIVE-2716 [jira] Move retry logic in 
HiveMetaStore to a separe class.

  +1 will commit if tests pass.

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

BRANCH
  ms-retry-logic


 Move retry logic in HiveMetaStore to a separe class
 ---

 Key: HIVE-2716
 URL: https://issues.apache.org/jira/browse/HIVE-2716
 Project: Hive
  Issue Type: Sub-task
  Components: Metastore
Affects Versions: 0.9.0
Reporter: Enis Soztutar
Assignee: Enis Soztutar
 Attachments: HIVE-2716.D1227.1.patch, HIVE-2716.D1227.2.patch, 
 HIVE-2716.D1227.3.patch


 In HIVE-1219, method retrying for raw store operation are introduced to 
 handle jdo operations more robustly. However, the abstraction for the 
 RawStore operations can be moved to a separate class implementing RawStore, 
 which should clean up the code base for HiveMetaStore. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Phabricator (Commented) (JIRA)

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

Phabricator commented on HIVE-2792:
---

ashutoshc has requested changes to the revision HIVE-2792 [jira] 
SUBSTR(CAST(string AS BINARY)) produces unexpected results.

  Patch looks good. Can you update the testcase as I noted so that we have 
better coverage?

INLINE COMMENTS
  ql/src/test/results/clientpositive/ba_table_udfs.q.out:28 For a better test 
so that it captures variance in the rows, modify the test in ba_tables_udfs.q 
to SUBSTR(src.value AS BINARY), 3),
  SUBSTR(src.value AS BINARY), -4,3)




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

BRANCH
  DPAL-848


 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Reporter: Carl Steinbach
 Attachments: HIVE-2792.D1797.1.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Assigned] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Ashutosh Chauhan (Assigned) (JIRA)

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

Ashutosh Chauhan reassigned HIVE-2792:
--

Assignee: Navis

@Navis, Can you also please upload the updated patch directly on jira granting 
ASF perms?

 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Affects Versions: 0.8.0, 0.8.1
Reporter: Carl Steinbach
Assignee: Navis
 Fix For: 0.9.0

 Attachments: HIVE-2792.D1797.1.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Ashutosh Chauhan (Updated) (JIRA)

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

Ashutosh Chauhan updated HIVE-2792:
---

Affects Version/s: 0.8.0
   0.8.1
Fix Version/s: 0.9.0

 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Affects Versions: 0.8.0, 0.8.1
Reporter: Carl Steinbach
Assignee: Navis
 Fix For: 0.9.0

 Attachments: HIVE-2792.D1797.1.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Phabricator (Updated) (JIRA)

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

Phabricator updated HIVE-2792:
--

Attachment: HIVE-2792.D1797.2.patch

navis updated the revision HIVE-2792 [jira] SUBSTR(CAST(string AS BINARY)) 
produces unexpected results.
Reviewers: JIRA, ashutoshc

  added test cases requested

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

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/udf/UDFSubstr.java
  ql/src/test/queries/clientpositive/ba_table_udfs.q
  ql/src/test/queries/clientpositive/udf_substr.q
  ql/src/test/results/clientpositive/ba_table_udfs.q.out
  ql/src/test/results/clientpositive/udf_substr.q.out


 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Affects Versions: 0.8.0, 0.8.1
Reporter: Carl Steinbach
Assignee: Navis
 Fix For: 0.9.0

 Attachments: HIVE-2792.D1797.1.patch, HIVE-2792.D1797.2.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-123) refactor DDL code (both DDLWork and DDLTask)

2012-02-20 Thread Phabricator (Updated) (JIRA)

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

Phabricator updated HIVE-123:
-

Attachment: HIVE-123.D1803.1.patch

dmitrys requested code review of HIVE-123 [jira] refactor DDL code (both 
DDLWork and DDLTask).
Reviewers: kevinwilfong, JIRA

  [Task #675564] Throw a Hive error if we're in strict mode and a the types of 
a partition comparison do not match.

  Added the check in strict mode.

  Task ID: #675564

  It might be good to break DDLTask into separate tasks. The abstract class 
DDLWork can have various subclasses:
  showTablesWork, DescribeTableWork etc. and a separate task for each of them. 
This will make them completely independent.

TEST PLAN
  Run the negative test select_partcol_diff_types.q

  Revert Plan: revert the changes of the commit

  Tags: hive

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

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/parse/ErrorMsg.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeGenericFuncDesc.java
  ql/src/test/queries/clientnegative/select_partcol_diff_types.q
  ql/src/test/results/clientnegative/select_partcol_diff_types.q.out

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

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

Tip: use the X-Herald-Rules header to filter Herald messages in your client.


 refactor DDL code (both DDLWork and DDLTask)
 

 Key: HIVE-123
 URL: https://issues.apache.org/jira/browse/HIVE-123
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Reporter: Namit Jain
Assignee: Ashutosh Chauhan
  Labels: cleanup, refactoring
 Attachments: HIVE-123.D1485.1.patch, HIVE-123.D1485.2.patch, 
 HIVE-123.D1803.1.patch, hive-123.patch


 It might be good to break DDLTask into separate tasks. The abstract class 
 DDLWork can have various subclasses:
 showTablesWork, DescribeTableWork etc. and a separate task for each of them. 
 This will make them completely independent.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2813) Throw a Hive error if we're in strict mode and a the types of a partition comparison do not match.

2012-02-20 Thread Dmitry Soshnikov (Commented) (JIRA)

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

Dmitry Soshnikov commented on HIVE-2813:


https://reviews.facebook.net/D1803

 Throw a Hive error if we're in strict mode and a the types of a partition 
 comparison do not match.
 --

 Key: HIVE-2813
 URL: https://issues.apache.org/jira/browse/HIVE-2813
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
Affects Versions: 0.8.1, 0.9.0
Reporter: Dmitry Soshnikov
Priority: Minor
  Labels: newbie, patch
 Fix For: 0.9.0

 Attachments: HIVE-2813.D1803.2.patch

   Original Estimate: 24h
  Remaining Estimate: 24h

 Oftentimes people try to write queries like
 SELECT *
 FROM table
 WHERE ds = 2011-08-03
 This won't work because quotes are missing, and it'll actually try to filter 
 on ds = 2000.
 People run into this pretty regularly; a simple check on whether the types 
 match exactly in partition predicates would make this a lot less likely to 
 happen.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2732) Reduce Sink deduplication fails if the child reduce sink is followed by a join

2012-02-20 Thread Phabricator (Updated) (JIRA)

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

Phabricator updated HIVE-2732:
--

Attachment: HIVE-2732.D1809.1.patch

navis requested code review of HIVE-2732 [jira] Reduce Sink deduplication 
fails if the child reduce sink is followed by a join.
Reviewers: JIRA

  DPAL-854 Reduce Sink deduplication fails if the child reduce sink is followed 
by a join

  set hive.optimize.reducededuplication=true;
  set hive.auto.convert.join=true;
  explain select * from (select * from src distribute by key sort by key) a 
join src b on a.key = b.key;

  fails with the following exception

  java.lang.ClassCastException: org.apache.hadoop.hive.ql.exec.SelectOperator 
cannot be cast to org.apache.hadoop.hive.ql.exec.ReduceSinkOperator
at 
org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.convertMapJoin(MapJoinProcessor.java:313)
at 
org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinOpAndLocalWork(MapJoinProcessor.java:226)
at 
org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver$CommonJoinTaskDispatcher.processCurrentTask(CommonJoinResolver.java:174)
at 
org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver$CommonJoinTaskDispatcher.dispatch(CommonJoinResolver.java:287)
at 
org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111)
at 
org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:194)
at 
org.apache.hadoop.hive.ql.lib.TaskGraphWalker.startWalking(TaskGraphWalker.java:139)
at 
org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver.resolve(CommonJoinResolver.java:68)
at 
org.apache.hadoop.hive.ql.optimizer.physical.PhysicalOptimizer.optimize(PhysicalOptimizer.java:72)
at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genMapRedTasks(SemanticAnalyzer.java:7019)
at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7312)
at 
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243)
at 
org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:48)
at 
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:430)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:337)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:889)
at 
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:255)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:212)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554)
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 org.apache.hadoop.util.RunJar.main(RunJar.java:156)

  If hive.auto.convert.join is set to false, it produces an incorrect plan 
where the two halves of the join are processed in two separate map reduce 
tasks, and the reducers of these two tasks both contain the join operator 
resulting in an exception.

TEST PLAN
  EMPTY

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

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/ReduceSinkDeDuplication.java
  ql/src/test/queries/clientpositive/reduce_deduplicate_exclude_gby.q
  ql/src/test/results/clientpositive/reduce_deduplicate_exclude_gby.q.out

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

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

Tip: use the X-Herald-Rules header to filter Herald messages in your client.


 Reduce Sink deduplication fails if the child reduce sink is followed by a join
 --

 Key: HIVE-2732
 URL: https://issues.apache.org/jira/browse/HIVE-2732
 Project: Hive
  Issue Type: Bug
Reporter: Kevin Wilfong
 Attachments: HIVE-2732.D1809.1.patch


 set hive.optimize.reducededuplication=true;
 set hive.auto.convert.join=true;
 explain select * from (select * from src distribute by key sort by key) a 
 join src b on a.key = b.key;
 fails with the following exception
 java.lang.ClassCastException: org.apache.hadoop.hive.ql.exec.SelectOperator 
 cannot be cast to org.apache.hadoop.hive.ql.exec.ReduceSinkOperator
   at 
 

[jira] [Commented] (HIVE-2737) CombineFileInputFormat fails if mapred.job.tracker is set to local with a sub-query

2012-02-20 Thread Navis (Commented) (JIRA)

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

Navis commented on HIVE-2737:
-

Similar problem with https://issues.apache.org/jira/browse/HIVE-2778

Hadoop-CDH3 removes scheme part of path URI in the CombineFileInputFormat, in 
this case 'file:///', which causes various problems in hive(HIVE-2778, 
HIVE-2784). 

 CombineFileInputFormat fails if mapred.job.tracker is set to local with a 
 sub-query
 ---

 Key: HIVE-2737
 URL: https://issues.apache.org/jira/browse/HIVE-2737
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 0.8.0
Reporter: Esteban Gutierrez

 If the CombineFileInputFormat and mapred.job.tracker=local are used together, 
 the CombineFileInputFormat throws a java.io.FileNotFoundException if the 
 query statment contains a sub-query:
 {code}
 hive select count(*) from (select count(*), a from hivetest2 group by a) x; 
 Total MapReduce jobs = 2 
 Launching Job 1 out of 2 
 Number of reduce tasks not specified. Estimated from input data size: 1 
 In order to change the average load for a reducer (in bytes): 
 set hive.exec.reducers.bytes.per.reducer=number 
 In order to limit the maximum number of reducers: 
 set hive.exec.reducers.max=number 
 In order to set a constant number of reducers: 
 set mapred.reduce.tasks=number 
 Execution log at: 
 /tmp/esteban/esteban_20120119134040_5d105797-1444-43ce-8ca8-3b4735b7a70d.log 
 Job running in-process (local Hadoop) 
 2012-01-19 13:40:49,618 null map = 100%, reduce = 100% 
 Ended Job = job_local_0001 
 Launching Job 2 out of 2 
 Number of reduce tasks determined at compile time: 1 
 In order to change the average load for a reducer (in bytes): 
 set hive.exec.reducers.bytes.per.reducer=number 
 In order to limit the maximum number of reducers: 
 set hive.exec.reducers.max=number 
 In order to set a constant number of reducers: 
 set mapred.reduce.tasks=number 
 Execution log at: 
 /tmp/esteban/esteban_20120119134040_5d105797-1444-43ce-8ca8-3b4735b7a70d.log 
 java.io.FileNotFoundException: File does not exist: 
 /tmp/esteban/hive_2012-01-19_13-40-45_277_494412568828098242/-mr-10002/00_0
  
 at 
 org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:546)
  
 at 
 org.apache.hadoop.mapred.lib.CombineFileInputFormat$OneFileInfo.init(CombineFileInputFormat.java:462)
  
 at 
 org.apache.hadoop.mapred.lib.CombineFileInputFormat.getMoreSplits(CombineFileInputFormat.java:256)
  
 at 
 org.apache.hadoop.mapred.lib.CombineFileInputFormat.getSplits(CombineFileInputFormat.java:212)
  
 at 
 org.apache.hadoop.hive.shims.Hadoop20SShims$CombineFileInputFormatShim.getSplits(Hadoop20SShims.java:347)
  
 at 
 org.apache.hadoop.hive.shims.Hadoop20SShims$CombineFileInputFormatShim.getSplits(Hadoop20SShims.java:313)
  
 at 
 org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getSplits(CombineHiveInputFormat.java:377)
  
 at org.apache.hadoop.mapred.JobClient.writeOldSplits(JobClient.java:971) 
 at org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:963) 
 at org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170) 
 at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:880) 
 at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833) 
 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:1127)
  
 at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:833) 
 at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:807) 
 at org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:671) 
 at org.apache.hadoop.hive.ql.exec.ExecDriver.main(ExecDriver.java:1092) 
 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 org.apache.hadoop.util.RunJar.main(RunJar.java:186) 
 Job Submission failed with exception 'java.io.FileNotFoundException(File does 
 not exist: 
 /tmp/esteban/hive_2012-01-19_13-40-45_277_494412568828098242/-mr-10002/00_0)'
 {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Phabricator (Commented) (JIRA)

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

Phabricator commented on HIVE-2792:
---

ashutoshc has accepted the revision HIVE-2792 [jira] SUBSTR(CAST(string AS 
BINARY)) produces unexpected results.

  +1 Will commit if tests pass.

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

BRANCH
  DPAL-848


 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Affects Versions: 0.8.0, 0.8.1
Reporter: Carl Steinbach
Assignee: Navis
 Fix For: 0.9.0

 Attachments: HIVE-2792.D1797.1.patch, HIVE-2792.D1797.2.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Navis (Updated) (JIRA)

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

Navis updated HIVE-2792:


Attachment: HIVE-2792.D1797.2.patch

 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Affects Versions: 0.8.0, 0.8.1
Reporter: Carl Steinbach
Assignee: Navis
 Fix For: 0.9.0

 Attachments: HIVE-2792.D1797.1.patch, HIVE-2792.D1797.2.patch, 
 HIVE-2792.D1797.2.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Assigned] (HIVE-2684) Provide compile + run method for HiveServer interface

2012-02-20 Thread Navis (Assigned) (JIRA)

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

Navis reassigned HIVE-2684:
---

Assignee: Navis

 Provide compile + run method for HiveServer interface
 -

 Key: HIVE-2684
 URL: https://issues.apache.org/jira/browse/HIVE-2684
 Project: Hive
  Issue Type: Improvement
  Components: Server Infrastructure
Reporter: Navis
Assignee: Navis
Priority: Minor
 Fix For: 0.9.0

 Attachments: HIVE-2684.D1041.1.patch, HIVE-2684.D1041.2.patch


 In our use cases, we need to access query plan in early time (before 
 execution). 
 1. compile
 2. get query plan
 3. setup configuration (callback, etc.)
 4. run the query
 Additional methods are needed for 1, 3, 4 stage.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2677) Joins involving where statements with a partition do not prune correctly in left outer join

2012-02-20 Thread Navis (Commented) (JIRA)

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

Navis commented on HIVE-2677:
-

For left-outer join, predicates on left condition only could be pushed down.

 Joins involving where statements with a partition do not prune correctly in 
 left outer join
 ---

 Key: HIVE-2677
 URL: https://issues.apache.org/jira/browse/HIVE-2677
 Project: Hive
  Issue Type: Bug
Affects Versions: 0.7.0
Reporter: Jakob Homan

 The following query:
 {noformat}
 select t1.id as m_id, count(t2.id) as totals 
 from table1 t1 left outer join table2 t2 on (t1.id = t2.id) 
 where (datepartition ==  '2011-11-08-00') 
 group by t1.id;{noformat}
 should prune to just a single partition (datepartition ==  '2011-11-08-00') . 
  However, the filter is being applied in the reducer, so a full table scan is 
 being done as part of the map.
 One can get the correct behavior by pushing the filter into a select 
 statement within the join itself:
 {noformat}select t1.id as m_id, count(p.id) as totals 
 from table1 t1 left outer join (select * from table2 where datepartition ==  
 '2011-11-08-00') t2 on (t1.id = t2.id)  
 group by t1.id;{noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-895) Add SerDe for Avro serialized data

2012-02-20 Thread Carl Steinbach (Commented) (JIRA)

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

Carl Steinbach commented on HIVE-895:
-

@Jakob: Do you think we can get this committed in time for the 0.9.0 release? 
Are you willing to attach a patch? Thanks.

 Add SerDe for Avro serialized data
 --

 Key: HIVE-895
 URL: https://issues.apache.org/jira/browse/HIVE-895
 Project: Hive
  Issue Type: New Feature
  Components: Serializers/Deserializers
Reporter: Jeff Hammerbacher
Assignee: Jakob Homan

 As Avro continues to mature, having a SerDe to allow HiveQL queries over Avro 
 data seems like a solid win.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2716) Move retry logic in HiveMetaStore to a separe class

2012-02-20 Thread Ashutosh Chauhan (Commented) (JIRA)

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

Ashutosh Chauhan commented on HIVE-2716:


ant  test -Dtestcase=TestNegativeCliDriver -Dqfile=authorization_fail_1.q 
failed.

 Move retry logic in HiveMetaStore to a separe class
 ---

 Key: HIVE-2716
 URL: https://issues.apache.org/jira/browse/HIVE-2716
 Project: Hive
  Issue Type: Sub-task
  Components: Metastore
Affects Versions: 0.9.0
Reporter: Enis Soztutar
Assignee: Enis Soztutar
 Attachments: HIVE-2716.D1227.1.patch, HIVE-2716.D1227.2.patch, 
 HIVE-2716.D1227.3.patch


 In HIVE-1219, method retrying for raw store operation are introduced to 
 handle jdo operations more robustly. However, the abstraction for the 
 RawStore operations can be moved to a separate class implementing RawStore, 
 which should clean up the code base for HiveMetaStore. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

2012-02-20 Thread Phabricator (Commented) (JIRA)

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

Phabricator commented on HIVE-2789:
---

ashutoshc has accepted the revision HIVE-2789 [jira] When integrating into 
MapReduce2, 'select * from src distribute by src.key limit 1' returns 
non-deterministic result.

  +1 will commit if tests pass.

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

BRANCH
  HIVE-2789-query-properties


 When integrating into MapReduce2, 'select * from src distribute by src.key 
 limit 1' returns non-deterministic result
 

 Key: HIVE-2789
 URL: https://issues.apache.org/jira/browse/HIVE-2789
 Project: Hive
  Issue Type: Bug
Reporter: Zhenxiao Luo
Assignee: Carl Steinbach
 Attachments: HIVE-2789.D1647.1.patch, HIVE-2789.D1647.1.patch


 query_properties.q test failure:
 [junit] Begin query: query_properties.q
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: 

[jira] [Commented] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

2012-02-20 Thread Ashutosh Chauhan (Commented) (JIRA)

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

Ashutosh Chauhan commented on HIVE-2789:


Carl,
Patch failed to apply cleanly for me. I have reviewed it. Looks good. Can you 
update the patch, test and commit?

 When integrating into MapReduce2, 'select * from src distribute by src.key 
 limit 1' returns non-deterministic result
 

 Key: HIVE-2789
 URL: https://issues.apache.org/jira/browse/HIVE-2789
 Project: Hive
  Issue Type: Bug
Reporter: Zhenxiao Luo
Assignee: Carl Steinbach
 Attachments: HIVE-2789.D1647.1.patch, HIVE-2789.D1647.1.patch


 query_properties.q test failure:
 [junit] Begin query: query_properties.q
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use 

[jira] [Updated] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

2012-02-20 Thread Ashutosh Chauhan (Updated) (JIRA)

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

Ashutosh Chauhan updated HIVE-2791:
---

Fix Version/s: 0.9.0

+1. Will commit if tests pass.

 filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
 --

 Key: HIVE-2791
 URL: https://issues.apache.org/jira/browse/HIVE-2791
 Project: Hive
  Issue Type: Bug
Reporter: binlijin
Assignee: binlijin
 Fix For: 0.9.0

 Attachments: HIVE-2791.2.patch, HIVE-2791.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

2012-02-20 Thread Phabricator (Updated) (JIRA)

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

Phabricator updated HIVE-2789:
--

Attachment: HIVE-2789.D1647.2.patch

cwsteinbach updated the revision HIVE-2789 [jira] When integrating into 
MapReduce2, 'select * from src distribute by src.key limit 1' returns 
non-deterministic result.
Reviewers: JIRA, kevinwilfong, ashutoshc

  Rebased patch on top of trunk.

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

AFFECTED FILES
  ql/src/test/queries/clientpositive/query_properties.q
  ql/src/test/results/clientpositive/query_properties.q.out


 When integrating into MapReduce2, 'select * from src distribute by src.key 
 limit 1' returns non-deterministic result
 

 Key: HIVE-2789
 URL: https://issues.apache.org/jira/browse/HIVE-2789
 Project: Hive
  Issue Type: Bug
  Components: Tests
Reporter: Zhenxiao Luo
Assignee: Carl Steinbach
 Attachments: HIVE-2789.D1647.1.patch, HIVE-2789.D1647.1.patch, 
 HIVE-2789.D1647.2.patch


 query_properties.q test failure:
 [junit] Begin query: query_properties.q
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 

[jira] [Updated] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

2012-02-20 Thread Carl Steinbach (Updated) (JIRA)

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

Carl Steinbach updated HIVE-2789:
-

Component/s: Tests

 When integrating into MapReduce2, 'select * from src distribute by src.key 
 limit 1' returns non-deterministic result
 

 Key: HIVE-2789
 URL: https://issues.apache.org/jira/browse/HIVE-2789
 Project: Hive
  Issue Type: Bug
  Components: Tests
Reporter: Zhenxiao Luo
Assignee: Carl Steinbach
 Attachments: HIVE-2789.D1647.1.patch, HIVE-2789.D1647.1.patch, 
 HIVE-2789.D1647.2.patch


 query_properties.q test failure:
 [junit] Begin query: query_properties.q
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:22 WARN conf.Configuration: mapred.local.dir is 
 deprecated. 

[jira] [Resolved] (HIVE-2725) Fix flaky testing infrastructure

2012-02-20 Thread Ashutosh Chauhan (Resolved) (JIRA)

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

Ashutosh Chauhan resolved HIVE-2725.


   Resolution: Fixed
Fix Version/s: 0.9.0
 Assignee: Ashutosh Chauhan

Trunk is green now. Resolving this as fixed. Only remaining issue is HIVE-2811

 Fix flaky testing infrastructure 
 -

 Key: HIVE-2725
 URL: https://issues.apache.org/jira/browse/HIVE-2725
 Project: Hive
  Issue Type: Bug
  Components: Testing Infrastructure
Affects Versions: 0.9.0
Reporter: Ashutosh Chauhan
Assignee: Ashutosh Chauhan
 Fix For: 0.9.0


 To begin with  
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_insert2_overwrite_partitions
  and org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_inputddl5 are 
 failing on trunk for a while now.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Updated] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

2012-02-20 Thread Carl Steinbach (Updated) (JIRA)

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

Carl Steinbach updated HIVE-2789:
-

Attachment: HIVE-2789.D1647.2.patch

 When integrating into MapReduce2, 'select * from src distribute by src.key 
 limit 1' returns non-deterministic result
 

 Key: HIVE-2789
 URL: https://issues.apache.org/jira/browse/HIVE-2789
 Project: Hive
  Issue Type: Bug
  Components: Tests
Reporter: Zhenxiao Luo
Assignee: Carl Steinbach
 Attachments: HIVE-2789.D1647.1.patch, HIVE-2789.D1647.1.patch, 
 HIVE-2789.D1647.2.patch, HIVE-2789.D1647.2.patch


 query_properties.q test failure:
 [junit] Begin query: query_properties.q
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:22 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:27 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:32 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:36 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:41 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:46 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:50 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:55 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 16:59:59 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:04 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:08 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:13 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:18 WARN conf.Configuration: mapred.local.dir is 
 deprecated. Instead, use mapreduce.cluster.local.dir
 [junit] 12/01/23 17:00:22 WARN conf.Configuration: mapred.system.dir is 
 deprecated. Instead, use mapreduce.jobtracker.system.dir
 [junit] 12/01/23 17:00:22 WARN 

HIVE-2773 is ready for review

2012-02-20 Thread Francis Liu
Hi,

HIVE-2773 is ready for review. Would be great to get feedback on this. It's
part of the effort in Hcatalog to use Hive's storageHandler and make the
written storageHandlers interoperable.

-Francis




[jira] [Resolved] (HIVE-2792) SUBSTR(CAST(string AS BINARY)) produces unexpected results

2012-02-20 Thread Ashutosh Chauhan (Resolved) (JIRA)

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

Ashutosh Chauhan resolved HIVE-2792.


Resolution: Fixed

Committed to trunk. Thanks, Navis!

 SUBSTR(CAST(string AS BINARY)) produces unexpected results
 

 Key: HIVE-2792
 URL: https://issues.apache.org/jira/browse/HIVE-2792
 Project: Hive
  Issue Type: Bug
  Components: UDF
Affects Versions: 0.8.0, 0.8.1
Reporter: Carl Steinbach
Assignee: Navis
 Fix For: 0.9.0

 Attachments: HIVE-2792.D1797.1.patch, HIVE-2792.D1797.2.patch, 
 HIVE-2792.D1797.2.patch




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira