Error while creating druid table

[justmail...@gmail.com]

Hi Team,

I am facing the error while creating table. Could you please help us.


[root@ip-10-230-245-117 hive]# beeline -u
"jdbc:hive2://ip-10-230-245-117.ec2.internal:2181,ip-10-230-245-1.ec2.internal:2181,ip-10-230-245-193.ec2.internal:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2"
Connecting to jdbc:hive2://ip-10-230-245-117.ec2.internal:2181,ip-10-230-245-1.ec2.internal:2181,ip-10-230-245-193.ec2.internal:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2
Connected to: Apache Hive (version 2.1.0.2.6.3.0-235)
Driver: Hive JDBC (version 1.2.1000.2.6.3.0-235)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.1000.2.6.3.0-235 by Apache Hive
0: jdbc:hive2://ip-10-230-245-117.ec2.interna> CREATE TABLE druid_table_1
0: jdbc:hive2://ip-10-230-245-117.ec2.interna> (`__time` TIMESTAMP,
`dimension1` STRING, `dimension2` STRING, `metric1` INT, `metric2`
FLOAT)
0: jdbc:hive2://ip-10-230-245-117.ec2.interna> STORED BY
'org.apache.hadoop.hive.druid.DruidStorageHandler';
INFO : Compiling
command(queryId=hive_20180419060747_4845a8b1-02e1-4f1b-bdf2-77c2ce6d94ff):
CREATE TABLE druid_table_1
(`__time` TIMESTAMP, `dimension1` STRING, `dimension2` STRING,
`metric1` INT, `metric2` FLOAT)
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
INFO : We are setting the hadoop caller context from
HIVE_SSN_ID:4b1c47c9-e2e1-4085-ab04-f2165b7eb056 to
hive_20180419060747_4845a8b1-02e1-4f1b-bdf2-77c2ce6d94ff
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO : Completed compiling
command(queryId=hive_20180419060747_4845a8b1-02e1-4f1b-bdf2-77c2ce6d94ff);
Time taken: 0.008 seconds
INFO : We are resetting the hadoop caller context to
HIVE_SSN_ID:4b1c47c9-e2e1-4085-ab04-f2165b7eb056
INFO : Setting caller context to query id
hive_20180419060747_4845a8b1-02e1-4f1b-bdf2-77c2ce6d94ff
INFO : Executing
command(queryId=hive_20180419060747_4845a8b1-02e1-4f1b-bdf2-77c2ce6d94ff):
CREATE TABLE druid_table_1
(`__time` TIMESTAMP, `dimension1` STRING, `dimension2` STRING,
`metric1` INT, `metric2` FLOAT)
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
INFO : Starting task [Stage-0:DDL] in serial mode
ERROR : FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask.
org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException:
java.sql.SQLException: Cannot create PoolableConnectionFactory
(Communications link failure

The last packet sent successfully to the server was 0 milliseconds
ago. The driver has not received any packets from the server.)
INFO : Resetting the caller context to
HIVE_SSN_ID:4b1c47c9-e2e1-4085-ab04-f2165b7eb056
INFO : Completed executing
command(queryId=hive_20180419060747_4845a8b1-02e1-4f1b-bdf2-77c2ce6d94ff);
Time taken: 253.44 seconds
Error: Error while processing statement: FAILED: Execution Error,
return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException:
java.sql.SQLException: Cannot create PoolableConnectionFactory
(Communications link failure

The last packet sent successfully to the server was 0 milliseconds
ago. The driver has not received any packets from the server.)
(state=08S01,code=1)
0: jdbc:hive2://ip-10-230-245-117.ec2.interna>
0: jdbc:hive2://ip-10-230-245-117.ec2.interna>

Thanks in advance

Regards,
Sandeep

[Gian Merlino]

Hi Sandeep,

This looks like a better question for the Hive community.

Gian

--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/5c86400e-c448-4cd8-8b16-27a5ba25243d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.