[
https://issues.apache.org/jira/browse/HIVE-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15295707#comment-15295707
]
Vijay Singh commented on HIVE-13817:
------------------------------------
Also ran the same tests with impala using modified jdbc driver and SSL turned
on successfully.
{code}
[root@vjd-1 ~]# beeline -u
"jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true"
-e "show tables;"
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated
and will likely be removed in a future release
16/05/22 13:02:47 WARN mapreduce.TableMapReduceUtil: The hbase-prefix-tree
module jar containing PrefixTreeCodec is not present. Continuing without it.
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
scan complete in 2ms
Connecting to
jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true
Error: Could not open client transport with JDBC Uri:
jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true:
null (state=08S01,code=0)
No current connection
Error: Could not open client transport with JDBC Uri:
jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true:
null (state=08S01,code=0)
[root@vjd-1 ~]# beeline -u
"jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true"
-e "show tables;"
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated
and will likely be removed in a future release
16/05/22 13:03:16 WARN mapreduce.TableMapReduceUtil: The hbase-prefix-tree
module jar containing PrefixTreeCodec is not present. Continuing without it.
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
scan complete in 2ms
Connecting to
jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true
Connected to: Impala (version 2.5.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
customers
sample_07
sample_08
web_logs
+-------+--+
| name |
+-------+--+
+-------+--+
No rows selected (2.014 seconds)
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
Closing: 0:
jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true
[root@vjd-1 ~]# beeline -u
"jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true;useCanonicalName=true"
-e "show tables;"
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated
and will likely be removed in a future release
16/05/22 13:03:42 WARN mapreduce.TableMapReduceUtil: The hbase-prefix-tree
module jar containing PrefixTreeCodec is not present. Continuing without it.
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
scan complete in 2ms
Connecting to
jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true;useCanonicalName=true
Connected to: Impala (version 2.5.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
customers
sample_07
sample_08
web_logs
+-------+--+
| name |
+-------+--+
+-------+--+
No rows selected (2.027 seconds)
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
Closing: 0:
jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true;useCanonicalName=true
[root@vjd-1 ~]# beeline -u
"jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true;useCanonicalName=true"
-e "show tables;"
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated
and will likely be removed in a future release
16/05/22 13:04:05 WARN mapreduce.TableMapReduceUtil: The hbase-prefix-tree
module jar containing PrefixTreeCodec is not present. Continuing without it.
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
scan complete in 2ms
Connecting to
jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true;useCanonicalName=true
Connected to: Impala (version 2.5.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
customers
sample_07
sample_08
web_logs
+-------+--+
| name |
+-------+--+
+-------+--+
No rows selected (2.013 seconds)
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
Closing: 0:
jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/[email protected];ssl=true;useCanonicalName=true
[root@vjd-1 ~]#
{code}
> Allow DNS CNAME ALIAS Resolution from apache hive beeline JDBC URL to allow
> for failover
> ----------------------------------------------------------------------------------------
>
> Key: HIVE-13817
> URL: https://issues.apache.org/jira/browse/HIVE-13817
> Project: Hive
> Issue Type: New Feature
> Components: Beeline
> Affects Versions: 1.2.1
> Reporter: Vijay Singh
> Attachments: HIVE-13817.1.patch, HIVE-13817.2.patch,
> HIVE-13817.3.patch
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> Currently, in case of BDR clusters, DNS CNAME alias based connections fail.
> As _HOST resolves to exact endpoint specified in connection string and that
> may not be intended SPN for kerberos based on reverse DNS lookup.
> Consequently this JIRA proposes that client specific setting be used to
> resolv _HOST from CNAME DNS alias to A record entry on the fly in beeline.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
