[jira] [Created] (HIVE-23360) Unable to create Connection using the Ambari default PORT (working fine if Port is taken as 10000)
Sukhpreet Kaur created HIVE-23360: - Summary: Unable to create Connection using the Ambari default PORT (working fine if Port is taken as 1) Key: HIVE-23360 URL: https://issues.apache.org/jira/browse/HIVE-23360 Project: Hive Issue Type: Bug Components: Hive, HiveServer2, JDBC Environment: # hive version 3.1.0.3.0.1.0-187 * success -- hive jdbc used 3.0.0 -- * success -- hive jdbc used 2.0.0 -- * success -- hive jdbc used 2.1.0 -- * success -- hive jdbc used 2.2.0 -- * success -- hive jdbc used 2.1.1 -- * connection.setUrl( * "jdbc:hive2://xen188-hdp30-centos7:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" # hive version 1.2.1000.2.6.0.3-8 * failed -- hive jdbc used 3.0.0 -- * success -- hive jdbc used 2.0.0 -- * success -- hive jdbc used 2.1.0 -- * failed -- hive jdbc used 2.2.0 -- * failed -- hive jdbc used 2.1.1 -- * connection.setUrl( * "jdbc:hive2://rack167-hdp26-dev:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" * ); Reporter: Sukhpreet Kaur Attachments: HiveConnection.java, MainClass.java, build.gradle Unable to create a connection using the Ambari JDBC URL (port 2181). Working fine with the default port 1. Please look into the environment details (found after doing a lot of hit-and-trial) and attached files to further investigate the issue. Using a higher hive-jdbc version results in conflicts while deploying the project. Our R&D concluded that the issue mainly lies with the zookeeper jar. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (HIVE-23359) "show tables like" support for SQL wildcard characters (% and _)
Yuming Wang created HIVE-23359: -- Summary: "show tables like" support for SQL wildcard characters (% and _) Key: HIVE-23359 URL: https://issues.apache.org/jira/browse/HIVE-23359 Project: Hive Issue Type: Improvement Components: SQL Affects Versions: 2.3.7 Reporter: Yuming Wang https://docs.snowflake.com/en/sql-reference/sql/show-tables.html https://clickhouse.tech/docs/en/sql-reference/statements/show/ https://www.mysqltutorial.org/mysql-show-tables/ -- This message was sent by Atlassian Jira (v8.3.4#803005)
Re: Review Request 72431: HIVE-23206
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/72431/ --- (Updated May 4, 2020, 5:02 a.m.) Review request for hive, Jesús Camacho Rodríguez, Steve Carlin, and Vineet Garg. Bugs: HIVE-23206 https://issues.apache.org/jira/browse/HIVE-23206 Repository: hive-git Description --- Project not defined correctly after reordering a join Diffs (updated) - itests/src/test/resources/testconfiguration.properties 5468728f83 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinProjectTransposeRule.java 492c55e050 ql/src/test/queries/clientpositive/join_reorder5.q PRE-CREATION ql/src/test/results/clientpositive/join22.q.out ad34bc4310 ql/src/test/results/clientpositive/llap/correlationoptimizer3.q.out f063766a1f ql/src/test/results/clientpositive/llap/join_reorder5.q.out PRE-CREATION ql/src/test/results/clientpositive/llap/keep_uniform.q.out 54d0b5fab6 ql/src/test/results/clientpositive/llap/sharedwork.q.out f8d3b4b2f5 ql/src/test/results/clientpositive/llap/subquery_select.q.out 311cee743d ql/src/test/results/clientpositive/perf/tez/cbo_query2.q.out 26a98ffcec ql/src/test/results/clientpositive/perf/tez/cbo_query59.q.out abc5d999b5 ql/src/test/results/clientpositive/perf/tez/cbo_query95.q.out 218ca7d8b6 ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query14.q.out eaa1defa81 ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query2.q.out 4c90da4476 ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query59.q.out 8d17cc79d1 ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query95.q.out ace074316b ql/src/test/results/clientpositive/perf/tez/constraints/query14.q.out 8204245245 ql/src/test/results/clientpositive/perf/tez/constraints/query2.q.out 6669e6 ql/src/test/results/clientpositive/perf/tez/constraints/query59.q.out f7c7260077 ql/src/test/results/clientpositive/perf/tez/constraints/query95.q.out 39d35ec330 ql/src/test/results/clientpositive/perf/tez/query2.q.out 0e67e97c02 ql/src/test/results/clientpositive/perf/tez/query59.q.out 1a2ba964f4 ql/src/test/results/clientpositive/perf/tez/query95.q.out f15afbed4b ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 9547e4fa7c ql/src/test/results/clientpositive/smb_mapjoin_25.q.out 8fb82e1659 Diff: https://reviews.apache.org/r/72431/diff/4/ Changes: https://reviews.apache.org/r/72431/diff/3-4/ Testing --- mvn test -Dtest.output.overwrite -DskipSparkTests -Dtest=TestMiniLlapLocalCliDriver -Dqfile=join_reorder5.q -pl itests/qtest -Pitests Thanks, Krisztian Kasa
Review Request 72463: HIVE-23298
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/72463/ --- Review request for hive and Jesús Camacho Rodríguez. Bugs: HIVE-23298 https://issues.apache.org/jira/browse/HIVE-23298 Repository: hive-git Description --- rs_dedup Diffs - ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java da277d058f ql/src/test/results/clientpositive/llap/auto_join18.q.out 505ce8ca5b ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out c77bed7072 ql/src/test/results/clientpositive/llap/bucket2.q.out 9b82a96fc1 ql/src/test/results/clientpositive/llap/bucket4.q.out ea9dc76a3a ql/src/test/results/clientpositive/llap/bucket_num_reducers2.q.out 17f30f9e58 ql/src/test/results/clientpositive/llap/check_constraint.q.out e4fe16427f ql/src/test/results/clientpositive/llap/disable_merge_for_bucketing.q.out 389a5f2769 ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b396e454c7 ql/src/test/results/clientpositive/llap/distinct_stats.q.out f0daa4c4f1 ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out bb3b6c39f0 ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out 6abd6f3c82 ql/src/test/results/clientpositive/llap/except_all.q.out 4c2498f5a8 ql/src/test/results/clientpositive/llap/except_distinct.q.out 47f45c5cdd ql/src/test/results/clientpositive/llap/explainuser_1.q.out 7f0ce5a9c7 ql/src/test/results/clientpositive/llap/explainuser_2.q.out 6f275c6ecf ql/src/test/results/clientpositive/llap/groupby3_map.q.out 0bef509f54 ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out 2290c22814 ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out 258e54591e ql/src/test/results/clientpositive/llap/groupby4_map.q.out 7d4d7a0524 ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out eb53e25441 ql/src/test/results/clientpositive/llap/groupby5_map.q.out ddd0557df2 ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out b6d681b3f1 ql/src/test/results/clientpositive/llap/insert_into_default_keyword.q.out b7355fb2d2 ql/src/test/results/clientpositive/llap/intersect_all.q.out 549cca487a ql/src/test/results/clientpositive/llap/intersect_distinct.q.out 950bc4b68c ql/src/test/results/clientpositive/llap/limit_pushdown.q.out 63e524d5d4 ql/src/test/results/clientpositive/llap/mrr.q.out 628f91af1e ql/src/test/results/clientpositive/llap/offset_limit_ppd_optimizer.q.out 208646bba1 ql/src/test/results/clientpositive/llap/ptf.q.out c678e64902 ql/src/test/results/clientpositive/llap/reduce_deduplicate.q.out 9df57473f4 ql/src/test/results/clientpositive/llap/reduce_deduplicate_extended.q.out d15ea89888 ql/src/test/results/clientpositive/llap/reducesink_dedup.q.out 84c8223214 ql/src/test/results/clientpositive/llap/subquery_ANY.q.out 8fa69c5aaf ql/src/test/results/clientpositive/llap/subquery_in.q.out 60522c838b ql/src/test/results/clientpositive/llap/subquery_notin.q.out 3bb3a042a0 ql/src/test/results/clientpositive/llap/subquery_scalar.q.out 8fab16789b ql/src/test/results/clientpositive/llap/subquery_select.q.out 311cee743d ql/src/test/results/clientpositive/llap/tez_dml.q.out d716b63012 ql/src/test/results/clientpositive/llap/tez_union2.q.out 762a2a51d0 ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out d5bc1790d4 ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out aa92f46f17 ql/src/test/results/clientpositive/llap/unionDistinct_3.q.out 69c43706b2 ql/src/test/results/clientpositive/llap/vector_decimal_6.q.out e899da5c1f ql/src/test/results/clientpositive/llap/vector_groupby_reduce.q.out e74bc44680 ql/src/test/results/clientpositive/llap/vector_outer_reference_windowed.q.out cb086bd5a3 ql/src/test/results/clientpositive/llap/vector_ptf_1.q.out d4d22d05d8 ql/src/test/results/clientpositive/llap/vector_windowing.q.out ca3c6337bf ql/src/test/results/clientpositive/llap/vectorization_limit.q.out 36276e1fc9 ql/src/test/results/clientpositive/llap/vectorized_ptf.q.out 640e8f0dc3 ql/src/test/results/clientpositive/perf/tez/constraints/query51.q.out 257cb58c50 ql/src/test/results/clientpositive/perf/tez/constraints/query53.q.out 06726ba4a1 ql/src/test/results/clientpositive/perf/tez/constraints/query63.q.out cdcd316388 ql/src/test/results/clientpositive/perf/tez/query51.q.out 8e3c53dfc9 ql/src/test/results/clientpositive/perf/tez/query53.q.out 2d2c0c374e ql/src/test/results/clientpositive/perf/tez/query63.q.out 6d7a54a808 Diff: https://reviews.apache.org/r/72463/diff/1/ Testing --- Thanks, Ashutosh Chauhan