[jira] [Commented] (HIVE-2612) support hive table/partitions exists in more than one region

2012-02-11 Thread Hudson (Commented) (JIRA)

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

Hudson commented on HIVE-2612:
--

Integrated in Hive-trunk-h0.21 #1254 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1254/])
HIVE-2612 support hive table/partitions exists in more than one region
(Kevin Wilfong via namit)

namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1243013
Files : 
* /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
* /hive/trunk/conf/hive-default.xml.template
* /hive/trunk/contrib/src/test/results/clientnegative/serde_regex.q.out
* /hive/trunk/contrib/src/test/results/clientpositive/fileformat_base64.q.out
* /hive/trunk/contrib/src/test/results/clientpositive/serde_regex.q.out
* /hive/trunk/metastore/if/hive_metastore.thrift
* /hive/trunk/metastore/scripts/upgrade/derby/010-HIVE-2612.derby.sql
* /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.10.0.derby.sql
* /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.9.0-to-0.10.0.derby.sql
* /hive/trunk/metastore/scripts/upgrade/mysql/010-HIVE-2612.mysql.sql
* /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.10.0.mysql.sql
* /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.9.0-to-0.10.0.mysql.sql
* /hive/trunk/metastore/scripts/upgrade/postgres/010-HIVE-2612.postgres.sql
* /hive/trunk/metastore/src/gen/thrift/gen-cpp/ThriftHiveMetastore.cpp
* /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.cpp
* /hive/trunk/metastore/src/gen/thrift/gen-cpp/hive_metastore_types.h
* 
/hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Index.java
* 
/hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Partition.java
* 
/hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/RegionStorageDescriptor.java
* 
/hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Schema.java
* 
/hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/StorageDescriptor.java
* 
/hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java
* 
/hive/trunk/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/ThriftHiveMetastore.java
* /hive/trunk/metastore/src/gen/thrift/gen-php/ThriftHiveMetastore.php
* 
/hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore/ThriftHiveMetastore.php
* 
/hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore/hive_metastore_types.php
* /hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore_constants.php
* /hive/trunk/metastore/src/gen/thrift/gen-php/hive_metastore_types.php
* 
/hive/trunk/metastore/src/gen/thrift/gen-py/hive_metastore/ThriftHiveMetastore.py
* /hive/trunk/metastore/src/gen/thrift/gen-py/hive_metastore/ttypes.py
* /hive/trunk/metastore/src/gen/thrift/gen-rb/hive_metastore_types.rb
* 
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveAlterHandler.java
* 
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java
* 
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreUtils.java
* 
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
* 
/hive/trunk/metastore/src/model/org/apache/hadoop/hive/metastore/model/MRegionStorageDescriptor.java
* 
/hive/trunk/metastore/src/model/org/apache/hadoop/hive/metastore/model/MStorageDescriptor.java
* /hive/trunk/metastore/src/model/package.jdo
* 
/hive/trunk/metastore/src/test/org/apache/hadoop/hive/metastore/TestHiveMetaStore.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.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/ErrorMsg.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ImportSemanticAnalyzer.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/CreateTableDesc.java
* /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/metadata/TestHive.java
* /hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out
* /hive/trunk/ql/src/test/results/clientpositive/ctas.q.out
* /hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
* /hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out
* /hive/trunk/ql/src/test/results/clientpositive/input15.q.out
* /hive/trunk/ql/src/test/results/clientpositive/inputddl1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out
* /hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out
* /hive/trunk/ql/src/test/results/clientpositive/merge3.q.out
* 

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

2012-02-11 Thread Apache Jenkins Server
Changes for Build #1210
[namit] HIVE-2674 get_partitions_ps throws TApplicationException if table 
doesn't
exist (Kevin Wilfong via namit)


Changes for Build #1211
[cws] HIVE-2203. Extend concat_ws() UDF to support arrays of strings (Zhenxiao 
Luo via cws)

[cws] HIVE-2279. Implement sort(array) UDF (Zhenxiao Luo via cws)


Changes for Build #1212
[hashutosh] HIVE-2589 : Newly created partition should inherit properties from 
table (Ashutosh Chauhan)


Changes for Build #1213

Changes for Build #1214

Changes for Build #1215

Changes for Build #1216
[cws] HIVE-2724. Remove unused lib/log4j-1.2.15.jar (Andrew Bayer via cws)


Changes for Build #1217

Changes for Build #1218

Changes for Build #1219
[hashutosh] HIVE-2665 : Support for metastore service specific HADOOP_OPTS 
environment setting (thw via hashutosh)


Changes for Build #1220
[namit] HIVE-2727 add a testcase for partitioned view on union and base tables 
have
index (He Yongqiang via namit)


Changes for Build #1221
[hashutosh] HIVE-2746 : Metastore client doesn't log properly in case of 
connection failure to server (hashutosh)

[cws] HIVE-2698 [jira] Enable Hadoop-1.0.0 in Hive
(Enis Söztutar via Carl Steinbach)

Summary:
third version of the patch

Hadoop-1.0.0 is recently released, which is AFAIK, API compatible to the 0.20S
release.

Test Plan: EMPTY

Reviewers: JIRA, cwsteinbach

Reviewed By: cwsteinbach

CC: cwsteinbach, enis

Differential Revision: https://reviews.facebook.net/D1389


Changes for Build #1222
[namit] HIVE-2750 Hive multi group by single reducer optimization causes 
invalid column
reference error (Kevin Wilfong via namit)


Changes for Build #1223

Changes for Build #1224
[cws] HIVE-2734 [jira] Fix some nondeterministic test output
(Zhenxiao Luo via Carl Steinbach)

Summary:
HIVE-2734: Fix some nondeterministic test output

Many Hive query tests lack an ORDER BY clause, and consequently the ordering
of the rows in the result set is nondeterministic:

groupby1_limit
input11_limit
input1_limit
input_lazyserde
join18_multi_distinct
join_1to1
join_casesensitive
join_filters
join_nulls
merge3
rcfile_columnar
rcfile_lazydecompress
rcfile_union
sample10
udf_sentences
union24
columnarserde_create_shortcut
combine1
global_limit

Test Plan: EMPTY

Reviewers: JIRA, cwsteinbach

Reviewed By: cwsteinbach

CC: zhenxiao, cwsteinbach

Differential Revision: https://reviews.facebook.net/D1449

[namit] HIVE-2754 NPE in union with lateral view
(Yongqiang He via namit)


Changes for Build #1225

Changes for Build #1226

Changes for Build #1227
[namit] HIVE-2755 union follwowed by union_subq does not work if the subquery 
union
has reducers (He Yongqiang via namit)


Changes for Build #1228

Changes for Build #1229
[hashutosh] HIVE-2735: PlanUtils.configureTableJobPropertiesForStorageHandler() 
is not called for partitioned table (sushanth via ashutosh)


Changes for Build #1230
[cws] HIVE-2760 [jira] TestCliDriver should log elapsed time

Summary: HIVE-2760. TestCliDriver should log elapsed time

Test Plan: EMPTY

Reviewers: JIRA, ashutoshc

Reviewed By: ashutoshc

CC: ashutoshc, cwsteinbach

Differential Revision: https://reviews.facebook.net/D1503

[cws] HIVE-2662 [jira] Add Ant configuration property for dumping classpath of 
tests

Summary: HIVE-2662. Add Ant configuration property for dumping classpath of
tests

Test Plan: EMPTY

Reviewers: JIRA, jsichi, ashutoshc

Reviewed By: ashutoshc

CC: ashutoshc

Differential Revision: https://reviews.facebook.net/D903


Changes for Build #1231
[hashutosh] HIVE_2645: Hive Web Server startup messages logs incorrect path it 
is searching for WAR (Edward Capriolo via Ashutosh Chauhan)


Changes for Build #1232

Changes for Build #1233
[sdong] HIVE-2249 When creating constant expression for numbers, try to infer 
type from another comparison operand, instead of trying to use integer first, 
and then long and double (Zhiqiu Kong via Siying Dong)


Changes for Build #1234

Changes for Build #1235
[heyongqiang] HIVE-2765 hbase handler uses ZooKeeperConnectionException which 
is not compatible with HBase versions other than 0.89 (Pei Yue via He Yongqiang)


Changes for Build #1236

Changes for Build #1237

Changes for Build #1238
[heyongqiang] HIVE-2772 [jira] make union31.q deterministic
(Namit Jain via Yongqiang He)

Summary:
https://issues.apache.org/jira/browse/HIVE-2772

HIVE-2772



Test Plan: EMPTY

Reviewers: JIRA, ashutoshc

Reviewed By: ashutoshc

CC: ashutoshc

Differential Revision: https://reviews.facebook.net/D1557

[kevinwilfong] HIVE-2758 Metastore is caching too aggressively (Kevin Wilfong 
reviewed by Carl Steinbach)


Changes for Build #1239

Changes for Build #1240
[namit] HIVE-2762 Alter Table Partition Concatenate Fails On Certain Characters
(Kevin Wilfong via namit)


Changes for Build #1241
[namit] HIVE-2756 Views should be added to the inputs of queries.
(Yongqiang He via namit)


Changes for Build #1242

Changes for Build #1243

Changes for Build #1244

Changes for Build #1245


[jira] [Created] (HIVE-2801) When join key is null, random distribute this tuple

2012-02-11 Thread binlijin (Created) (JIRA)
When join key is null, random distribute this tuple
---

 Key: HIVE-2801
 URL: https://issues.apache.org/jira/browse/HIVE-2801
 Project: Hive
  Issue Type: Improvement
Reporter: binlijin




--
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-2801) When join key is null, random distribute this tuple

2012-02-11 Thread binlijin (Updated) (JIRA)

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

binlijin updated HIVE-2801:
---

Status: Patch Available  (was: Open)

 When join key is null, random distribute this tuple
 ---

 Key: HIVE-2801
 URL: https://issues.apache.org/jira/browse/HIVE-2801
 Project: Hive
  Issue Type: Improvement
Reporter: binlijin
 Attachments: HIVE-2801.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-2801) When join key is null, random distribute this tuple

2012-02-11 Thread binlijin (Updated) (JIRA)

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

binlijin updated HIVE-2801:
---

Attachment: HIVE-2801.patch

 When join key is null, random distribute this tuple
 ---

 Key: HIVE-2801
 URL: https://issues.apache.org/jira/browse/HIVE-2801
 Project: Hive
  Issue Type: Improvement
Reporter: binlijin
 Attachments: HIVE-2801.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] [Created] (HIVE-2802) When writing output files, OUTPUTFORMAT does not take effect.

2012-02-11 Thread Yifeng Geng (Created) (JIRA)
When writing output files, OUTPUTFORMAT does not take effect.
-

 Key: HIVE-2802
 URL: https://issues.apache.org/jira/browse/HIVE-2802
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 0.7.1
 Environment: hadoop-0.20.203
Reporter: Yifeng Geng


I want to query the input text and store the result as other format such as 
sequence file.

For example:
CREATE TABLE pokes (foo INT, bar STRING) STORED AS INPUTFORMAT 
'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 
'org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat';
LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO TABLE pokes; 
INSERT OVERWRITE DIRECTORY '/tmp/pokes_out' select * from pokes;

Result file in /tmp/pokes_out is in Text Format not 
HiveSequenceFileOutputFormat.
I dig into the source code, and it seems there is a property 
hive.query.result.fileformat that cause the result to be in text format.
Is it a bug and how to achieve my purpose?

--
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