[
https://issues.apache.org/jira/browse/HIVE-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15295473#comment-15295473
]
Vijay Singh commented on HIVE-13817:
------------------------------------
The last combination, where we use Canonicalname and canonicalname resolution
is turned on in connect string has been pasted below for reference as well.
{code}
Closing: 0:
jdbc:hive2://vjtest-local.gce.cloudera.com:10000/default;principal=hive/_h...@gce.cloudera.com
[root@vjd-1 ~]# beeline -u
"jdbc:hive2://vjtest-local.gce.cloudera.com:10000/default;principal=hive/_h...@gce.cloudera.com;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 01:33:24 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:10000/default;principal=hive/_h...@gce.cloudera.com;useCanonicalName=true
Connected to: Apache Hive (version 1.1.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
INFO : Compiling
command(queryId=hive_20160522013333_cd09f83a-5ce1-4cf9-8a3b-9175b00ed4bb): show
tables
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name,
type:string, comment:from deserializer)], properties:null)
INFO : Completed compiling
command(queryId=hive_20160522013333_cd09f83a-5ce1-4cf9-8a3b-9175b00ed4bb); Time
taken: 0.07 seconds
INFO : Executing
command(queryId=hive_20160522013333_cd09f83a-5ce1-4cf9-8a3b-9175b00ed4bb): show
tables
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing
command(queryId=hive_20160522013333_cd09f83a-5ce1-4cf9-8a3b-9175b00ed4bb); Time
taken: 0.135 seconds
INFO : OK
+------------+--+
| tab_name |
+------------+--+
| customers |
| sample_07 |
| sample_08 |
| web_logs |
+------------+--+
4 rows selected (0.357 seconds)
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
Closing: 0:
jdbc:hive2://vjtest-local.gce.cloudera.com:10000/default;principal=hive/_h...@gce.cloudera.com;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)
