hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6990) Direct SQL fails when the explicit schema setting is different from the default one
Date Wed, 30 Apr 2014 21:15:15 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13986094#comment-13986094
] 

Hive QA commented on HIVE-6990:
-------------------------------



{color:red}Overall{color}: -1 no tests executed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12642612/HIVE-6990.1.patch

Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/88/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/88/console

Messages:
{noformat}
**** This message was trimmed, see log for full details ****
Reverted 'ql/src/test/results/clientpositive/ppd_outer_join3.q.out'
Reverted 'ql/src/test/results/clientpositive/input42.q.out'
Reverted 'ql/src/test/results/clientpositive/having.q.out'
Reverted 'ql/src/test/results/clientpositive/quote1.q.out'
Reverted 'ql/src/test/results/clientpositive/index_auto_unused.q.out'
Reverted 'ql/src/test/results/clientpositive/join_vc.q.out'
Reverted 'ql/src/test/results/clientpositive/vector_non_string_partition.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join23.q.out'
Reverted 'ql/src/test/results/clientpositive/union15.q.out'
Reverted 'ql/src/test/results/clientpositive/udf5.q.out'
Reverted 'ql/src/test/results/clientpositive/sort_merge_join_desc_4.q.out'
Reverted 'ql/src/test/results/clientpositive/join16.q.out'
Reverted 'ql/src/test/results/clientpositive/nullgroup2.q.out'
Reverted 'ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out'
Reverted 'ql/src/test/results/clientpositive/limit_pushdown_negative.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin10.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join32.q.out'
Reverted 'ql/src/test/results/clientpositive/union24.q.out'
Reverted 'ql/src/test/results/clientpositive/index_auto.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_join.q.out'
Reverted 'ql/src/test/results/clientpositive/join_reorder4.q.out'
Reverted 'ql/src/test/results/clientpositive/metadata_only_queries.q.out'
Reverted 'ql/src/test/results/clientpositive/input2.q.out'
Reverted 'ql/src/test/results/clientpositive/vectorization_div0.q.out'
Reverted 'ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out'
Reverted 'ql/src/test/results/clientpositive/join11.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_15.q.out'
Reverted 'ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin1.q.out'
Reverted 'ql/src/test/results/clientpositive/correlationoptimizer14.q.out'
Reverted 'ql/src/test/results/clientpositive/metadata_only_queries_with_filters.q.out'
Reverted 'ql/src/test/results/clientpositive/join20.q.out'
Reverted 'ql/src/test/results/clientpositive/correlationoptimizer9.q.out'
Reverted 'ql/src/test/results/clientpositive/sample10.q.out'
Reverted 'ql/src/test/results/clientpositive/list_bucket_dml_5.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_10.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_rollup1.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_gby2.q.out'
Reverted 'ql/src/test/results/clientpositive/list_bucket_dml_13.q.out'
Reverted 'ql/src/test/results/clientpositive/vectorized_context.q.out'
Reverted 'ql/src/test/results/clientpositive/union_view.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_ppd.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_current_database.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt9.q.out'
Reverted 'ql/src/test/results/clientpositive/input39_hadoop20.q.out'
Reverted 'ql/src/test/results/clientpositive/correlationoptimizer4.q.out'
Reverted 'ql/src/test/results/clientpositive/vectorized_date_funcs.q.out'
Reverted 'ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out'
Reverted 'ql/src/test/results/clientpositive/louter_join_ppr.q.out'
Reverted 'ql/src/test/results/clientpositive/join_reorder.q.out'
Reverted 'ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out'
Reverted 'ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out'
Reverted 'ql/src/test/results/clientpositive/annotate_stats_join.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join0.q.out'
Reverted 'ql/src/test/results/clientpositive/quotedid_skew.q.out'
Reverted 'ql/src/test/results/clientpositive/subquery_notin.q.out'
Reverted 'ql/src/test/results/clientpositive/subquery_notexists_having.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt4.q.out'
Reverted 'ql/src/test/results/clientpositive/show_indexes_edge_cases.q.out'
Reverted 'ql/src/test/results/clientpositive/keyword_1.q.out'
Reverted 'ql/src/test/results/clientpositive/order.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_join3.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoin.q.out'
Reverted 'ql/src/test/results/clientpositive/mapjoin_distinct.q.out'
Reverted 'ql/src/test/results/clientpositive/vector_coalesce.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketcontext_8.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_inline.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt16.q.out'
Reverted 'ql/src/test/results/clientpositive/bucket_groupby.q.out'
Reverted 'ql/src/test/results/clientpositive/alias_casted_column.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_explode.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_sort_11.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_udtf.q.out'
Reverted 'ql/src/test/results/clientpositive/input26.q.out'
Reverted 'ql/src/test/results/clientpositive/join_merging.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_2.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketcontext_3.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join_without_localtask.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt11.q.out'
Reverted 'ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out'
Reverted 'ql/src/test/results/clientpositive/index_auto_self_join.q.out'
Reverted 'ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join16.q.out'
Reverted 'ql/src/test/results/clientpositive/bucket3.q.out'
Reverted 'ql/src/test/results/clientpositive/vector_between_in.q.out'
Reverted 'ql/src/test/results/clientpositive/input21.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_outer_join5.q.out'
Reverted 'ql/src/test/results/clientpositive/semijoin.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt20.q.out'
Reverted 'ql/src/test/results/clientpositive/show_columns.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_count.q.out'
Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out'
Reverted 'ql/src/test/results/clientpositive/subq_where_serialization.q.out'
Reverted 'ql/src/test/results/clientpositive/udf7.q.out'
Reverted 'ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out'
Reverted 'ql/src/test/results/clientpositive/join18.q.out'
Reverted 'ql/src/test/results/clientpositive/decimal_precision.q.out'
Reverted 'ql/src/test/results/clientpositive/nullgroup4.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin8.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join11.q.out'
Reverted 'ql/src/test/results/clientpositive/subq2.q.out'
Reverted 'ql/src/test/results/clientpositive/annotate_stats_filter.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin12.q.out'
Reverted 'ql/src/test/results/clientpositive/union26.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd1.q.out'
Reverted 'ql/src/test/results/clientpositive/cross_join.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_random.q.out'
Reverted 'ql/src/test/results/clientpositive/input4.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join20.q.out'
Reverted 'ql/src/test/results/clientpositive/udf2.q.out'
Reverted 'ql/src/test/results/clientpositive/sort_merge_join_desc_1.q.out'
Reverted 'ql/src/test/results/clientpositive/join13.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_17.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_repeated_alias.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out'
Reverted 'ql/src/test/results/clientpositive/union21.q.out'
Reverted 'ql/src/test/results/clientpositive/join22.q.out'
Reverted 'ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out'
Reverted 'ql/src/test/results/clientpositive/vector_left_outer_join.q.out'
Reverted 'ql/src/test/results/clientpositive/annotate_stats_part.q.out'
Reverted 'ql/src/test/results/clientpositive/symlink_text_input_format.q.out'
Reverted 'ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out'
Reverted 'ql/src/test/results/clientpositive/list_bucket_dml_7.q.out'
Reverted 'ql/src/test/results/clientpositive/index_stale.q.out'
Reverted 'ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out'
Reverted 'ql/src/test/results/clientpositive/metadataonly1.q.out'
Reverted 'ql/src/test/results/clientpositive/type_widening.q.out'
Reverted 'ql/src/test/results/clientpositive/escape_orderby1.q.out'
Reverted 'ql/src/test/results/clientpositive/union8.q.out'
Reverted 'ql/src/test/results/clientpositive/vectorized_math_funcs.q.out'
Reverted 'ql/src/test/results/clientpositive/correlationoptimizer11.q.out'
Reverted 'ql/src/test/results/clientpositive/multiMapJoin1.q.out'
Reverted 'ql/src/test/results/clientpositive/join40.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out'
Reverted 'ql/src/test/results/clientpositive/correlationoptimizer6.q.out'
Reverted 'ql/src/test/results/clientpositive/subquery_exists_having.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join18_multi_distinct.q.out'
Reverted 'ql/src/test/results/clientpositive/subquery_exists.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_gby.q.out'
Reverted 'ql/src/test/results/clientpositive/list_bucket_dml_2.q.out'
Reverted 'ql/src/test/results/clientpositive/select_transform_hint.q.out'
Reverted 'ql/src/test/results/clientpositive/outer_join_ppr.q.out'
Reverted 'ql/src/test/results/clientpositive/union_top_level.q.out'
Reverted 'ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_in_file.q.out'
Reverted 'ql/src/test/results/clientpositive/union3.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_sort_9.q.out'
Reverted 'ql/src/test/results/clientpositive/index_bitmap_auto.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt6.q.out'
Reverted 'ql/src/test/results/clientpositive/correlationoptimizer1.q.out'
Reverted 'ql/src/test/results/clientpositive/transform_ppr1.q.out'
Reverted 'ql/src/test/results/clientpositive/join0.q.out'
Reverted 'ql/src/test/results/clientpositive/escape_sortby1.q.out'
Reverted 'ql/src/test/results/clientpositive/regexp_extract.q.out'
Reverted 'ql/src/test/results/clientpositive/select_as_omitted.q.out'
Reverted 'ql/src/test/results/clientpositive/join_view.q.out'
Reverted 'ql/src/test/results/clientpositive/udaf_number_format.q.out'
Reverted 'ql/src/test/results/clientpositive/bucket_map_join_2.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt18.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt1.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_4.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out'
Reverted 'ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_union_view.q.out'
Reverted 'ql/src/test/results/clientpositive/lateral_view_outer.q.out'
Reverted 'ql/src/test/results/clientpositive/mergejoins.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_gby_join.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketcontext_5.q.out'
Reverted 'ql/src/test/results/clientpositive/escape_clusterby1.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt13.q.out'
Reverted 'ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out'
Reverted 'ql/src/test/results/clientpositive/cte_1.q.out'
Reverted 'ql/src/test/results/clientpositive/nullscript.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join18.q.out'
Reverted 'ql/src/test/results/clientpositive/input23.q.out'
Reverted 'ql/src/test/results/clientpositive/filter_numeric.q.out'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/ExplainSemanticAnalyzer.java'
++ awk '{print $2}'
++ egrep -v '^X|^Performing status on external'
++ svn status --no-ignore
+ rm -rf target datanucleus.log ant/target shims/target shims/0.20/target shims/0.20S/target
shims/0.23/target shims/aggregator/target shims/common/target shims/common-secure/target packaging/target
hbase-handler/target testutils/target jdbc/target metastore/target itests/target itests/hcatalog-unit/target
itests/test-serde/target itests/qtest/target itests/hive-minikdc/target itests/hive-unit/target
itests/custom-serde/target itests/util/target hcatalog/target hcatalog/core/target hcatalog/streaming/target
hcatalog/server-extensions/target hcatalog/webhcat/svr/target hcatalog/webhcat/java-client/target
hcatalog/hcatalog-pig-adapter/target hwi/target common/target common/src/gen contrib/target
service/target serde/target beeline/target odbc/target cli/target ql/dependency-reduced-pom.xml
ql/target
+ svn update

Fetching external item into 'hcatalog/src/test/e2e/harness'
External at revision 1591480.

At revision 1591480.
+ patchCommandPath=/data/hive-ptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hive-ptest/working/scratch/build.patch
+ [[ -f /data/hive-ptest/working/scratch/build.patch ]]
+ chmod +x /data/hive-ptest/working/scratch/smart-apply-patch.sh
+ /data/hive-ptest/working/scratch/smart-apply-patch.sh /data/hive-ptest/working/scratch/build.patch
The patch does not appear to apply with p0, p1, or p2
+ exit 1
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12642612

> Direct SQL fails when the explicit schema setting is different from the default one
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-6990
>                 URL: https://issues.apache.org/jira/browse/HIVE-6990
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.12.0
>         Environment: hive + derby
>            Reporter: Bing Li
>            Assignee: Bing Li
>             Fix For: 0.14.0
>
>         Attachments: HIVE-6990.1.patch
>
>
> I got the following ERROR in hive.log
> 2014-04-23 17:30:23,331 ERROR metastore.ObjectStore (ObjectStore.java:handleDirectSqlError(1756))
- Direct SQL failed, falling back to ORM
> javax.jdo.JDODataStoreException: Error executing SQL query "select PARTITIONS.PART_ID
from PARTITIONS  inner join TBLS on PARTITIONS.TBL_ID = TBLS.TBL_ID   inner join DBS on TBLS.DB_ID
= DBS.DB_ID inner join PARTITION_KEY_VALS as FILTER0 on FILTER0.PART_ID = PARTITIONS.PART_ID
and FILTER0.INTEGER_IDX = 0 where TBLS.TBL_NAME = ? and DBS.NAME = ? and ((FILTER0.PART_KEY_VAL
= ?))".
>         at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)
>         at org.datanucleus.api.jdo.JDOQuery.executeWithArray(JDOQuery.java:321)
>         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getPartitionsViaSqlFilterInternal(MetaStoreDirectSql.java:181)
>         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getPartitionsViaSqlFilter(MetaStoreDirectSql.java:98)
>         at org.apache.hadoop.hive.metastore.ObjectStore.getPartitionsByFilterInternal(ObjectStore.java:1833)
>         at org.apache.hadoop.hive.metastore.ObjectStore.getPartitionsByFilter(ObjectStore.java:1806)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
>         at java.lang.reflect.Method.invoke(Method.java:619)
>         at org.apache.hadoop.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:124)
>         at com.sun.proxy.$Proxy11.getPartitionsByFilter(Unknown Source)
>         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partitions_by_filter(HiveMetaStore.java:3310)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
>         at java.lang.reflect.Method.invoke(Method.java:619)
>         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:103)
>         at com.sun.proxy.$Proxy12.get_partitions_by_filter(Unknown Source)
> Reproduce steps:
> 1. set the following properties in hive-site.xml
>  <property>
>   <name>javax.jdo.mapping.Schema</name>
>   <value>HIVE</value>
>  </property>
>  <property>
>   <name>javax.jdo.option.ConnectionUserName</name>
>   <value>user1</value>
>  </property>
> 2. execute hive queries
> hive> create table mytbl ( key int, value string);
> hive> load data local inpath 'examples/files/kv1.txt' overwrite into table mytbl;
> hive> select * from mytbl;
> hive> create view myview partitioned on (value) as select key, value from mytbl where
key=98;
> hive> alter view myview add partition (value='val_98') partition (value='val_xyz');
> hive> alter view myview drop partition (value='val_xyz');



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message