hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vijay Singh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13817) Allow DNS CNAME ALIAS Resolution from apache hive beeline JDBC URL to allow for failover
Date Sun, 22 May 2016 20:07:12 GMT

    [ 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/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;ssl=true
Error: Could not open client transport with JDBC Uri: jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;ssl=true:
null (state=08S01,code=0)
[root@vjd-1 ~]# beeline -u "jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;ssl=true
[root@vjd-1 ~]# beeline -u "jdbc:hive2://vjtest-local.gce.cloudera.com:21050/default;principal=impala/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;ssl=true;useCanonicalName=true
[root@vjd-1 ~]# beeline -u "jdbc:hive2://vjlb.gce.cloudera.com:21050/default;principal=impala/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;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/_HOST@GCE.CLOUDERA.COM;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)

Mime
View raw message