Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

JDBC url for HDP2.5

Highlighted

JDBC url for HDP2.5

Rising Star

What will be the jdbc url to connect to beeline in HDP2.5 sandbox. Need this for checking ranger policy through beeline .

1 REPLY 1

Re: JDBC url for HDP2.5

Hi @Dinesh Das,

[root@sandbox ~]# beeline
Beeline version 1.2.1000.2.5.0.0-1245 by Apache Hive
beeline> !connect jdbc:hive2://localhost:10000
Connecting to jdbc:hive2://localhost:10000
Enter username for jdbc:hive2://localhost:10000: 
Enter password for jdbc:hive2://localhost:10000: 
Connected to: Apache Hive (version 1.2.1000.2.5.0.0-1245)
Driver: Hive JDBC (version 1.2.1000.2.5.0.0-1245)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000> show databases;
+----------------+--+
| database_name  |
+----------------+--+
| default        |
| foodmart       |
| xademo         |
+----------------+--+
3 rows selected (0.107 seconds)
0: jdbc:hive2://localhost:10000> use xademo;
No rows affected (0.038 seconds)
0: jdbc:hive2://localhost:10000> show tables;
+----------------------+--+
|       tab_name       |
+----------------------+--+
| call_detail_records  |
| customer_details     |
| recharge_details     |
+----------------------+--+
3 rows selected (0.126 seconds)
0: jdbc:hive2://localhost:10000> select * from customer_details;
+--------------------------------+------------------------+----------------------------+--------------------------+---------------------------+------------------------+--------------------------+--+
| customer_details.phone_number  | customer_details.plan  | customer_details.rec_date  | customer_details.status  | customer_details.balance  | customer_details.imei  | customer_details.region  |
+--------------------------------+------------------------+----------------------------+--------------------------+---------------------------+------------------------+--------------------------+--+
| PHONE_NUM                      | PLAN                   | REC_DATE                   | STAUS                    | BALANCE                   | IMEI                   | REGION                   |
| 5553947406                     | 6290                   | 20130328                   | 31                       | 0                         | 012565003040464        | R06                      |
| 7622112093                     | 2316                   | 20120625                   | 21                       | 28                        | 359896046017644        | R02                      |
| 5092111043                     | 6389                   | 20120610                   | 21                       | 293                       | 012974008373781        | R06                      |
| 9392254909                     | 4002                   | 20110611                   | 21                       | 178                       | 357004045763373        | R04                      |
| 7783343634                     | 2276                   | 20121214                   | 31                       | 0                         | 354643051707734        | R02                      |
| 5534292073                     | 6389                   | 20120223                   | 31                       | 83                        | 359896040168211        | R06                      |
| 9227087403                     | 4096                   | 20081010                   | 31                       | 35                        | 356927012514661        | R04                      |
| 9226203167                     | 4060                   | 20060527                   | 21                       | 450                       | 010589003666377        | R04                      |
| 9221154050                     | 4107                   | 20100811                   | 31                       | 3                         | 358665019197977        | R04                      |
| 7434378689                     | 2002                   | 20100824                   | 32                       | 0                         | 355000035507467        | R02                      |
| 7482285225                     | 2285                   | 20121130                   | 31                       | 52                        | 352212033537106        | R02                      |
| 7788070992                     | 2002                   | 20101214                   | 31                       | 17                        | 355384047786453        | R02                      |
| 7982300380                     | 2276                   | 20121223                   | 31                       | 0                         | 357210042170690        | R02                      |
| 9790142194                     | 4012                   | 20090406                   | 32                       | 0                         | 011336002603947        | R04                      |
| 9226907642                     | 4060                   | 20070312                   | 21                       | 93                        |                        | R04                      |
| 9559185951                     | 4276                   | 20120924                   | 31                       | 70                        | 355474044841748        | R04                      |
| 7582299877                     | 2389                   | 20120610                   | 31                       | 33                        | 356718041114890        | R02                      |
| 9422182637                     | 4060                   | 20041201                   | 31                       | 117                       | 010440007339548        | R04                      |
| 9291295360                     | 4324                   | 20120614                   | 21                       | 172                       | 353401045408575        | R04                      |
| 9452775584                     | 4325                   | 20120206                   | 21                       | 185                       | 011580001310174        | R04                      |
| 9752115932                     | 4002                   | 20100526                   | 21                       | 542                       | 358835035011748        | R04                      |
| 9882259323                     | 4012                   | 20101201                   | 31                       | 68                        | 012239002633949        | R04                      |
| 5922179682                     | 4282                   | 20130316                   | 21                       | 110                       | 354073042162536        | R04                      |
| 7482229731                     | 2368                   | 20090110                   | 21                       | 142                       | 357611009852016        | R02                      |
| 7984779801                     | 2276                   | 20121223                   | 31                       | 14                        | 013342000049057        | R02                      |
| 9562127711                     | 4107                   | 20110627                   | 21                       | 387                       |                        | R04                      |
| 9882297052                     | 4316                   | 20120107                   | 21                       | 97                        | 357118045463485        | R04                      |
| 9227677218                     | 4286                   | 20130121                   | 21                       | 70                        | 354894017753268        | R04                      |
| 9002245938                     | 4277                   | 20130131                   | 31                       | 0                         | 013111000005512        | R04                      |
+--------------------------------+------------------------+----------------------------+--------------------------+---------------------------+------------------------+--------------------------+--+
30 rows selected (0.204 seconds)