Closed RohanJ24 closed 5 years ago
Here is my hive.properties:
connector.name=hive-hadoop2 hive.metastore.uri=thrift://localhost:9083 hive.config.resources=/home/eweb/Downloads/hadoop/etc/hadoop/core-site.xml,/home/eweb/Downloads/hadoop/etc/hadoop/hdfs-site.xml
And here is my hive-site.xml :
<property> <name>hive.metastore.uri</name> <value>thrift://localhost:9083</value> </property> <property> <name>hive.metastore.schema.verification</name> <value>true</value> </property> <property> <name>hive.metastore.warehouse.dir</name> <value>/user/hive/warehouse</value> <description>location of default database for the warehouse</description> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost:3306/Demo?createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>root</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>password</value> </property>
I have tried this in terminal :
bin/presto --server localhost:8080 --catalog hive --schema bookvip presto:bookvip> SHOW SCHEMAS;
Is there any kind of setup error or any other error ??
Here is my hive.properties:
And here is my hive-site.xml :
I have tried this in terminal :
Is there any kind of setup error or any other error ??