xdgov / weehive Goto Github PK

0: jdbc:hive2://> INSERT INTO people (name) VALUES ('Aidan');
19/02/18 09:45:04 [HiveServer2-Background-Pool: Thread-50]: WARN ql.Driver: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
...
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
19/02/18 09:45:05 [HiveServer2-Background-Pool: Thread-50]: WARN impl.MetricsSystemImpl: JobTracker metrics system already initialized!
19/02/18 09:45:05 [HiveServer2-Background-Pool: Thread-50]: WARN mapreduce.JobResourceUploader: Hadoop command-line option parsing not performed. Implement the Tool interface and execute your application with ToolRunner to remedy this.
Job running in-process (local Hadoop)
WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
19/02/18 09:45:05 [LocalJobRunner Map Task Executor #0]: WARN objectinspector.StandardStructObjectInspector: Trying to access 6 fields inside a list of 7 elements: [String, 5, 5, 1, 0, 48 4c 4c a0 01 01 c3 dd b1 35, null]
19/02/18 09:45:05 [LocalJobRunner Map Task Executor #0]: WARN objectinspector.StandardStructObjectInspector: ignoring similar errors.
19/02/18 09:45:06 [pool-12-thread-1]: WARN impl.MetricsSystemImpl: JobTracker metrics system already initialized!
...
OK
No rows affected (5.168 seconds)

$ docker run --rm -it -p 10000:10000 \
     -v weehive_hadoop:/usr/local/hadoop/warehouse \
     -v weehive_meta:/usr/local/hadoop/metastore_db \
     weehive
Connecting to jdbc:hive2://
Hive Session ID = 99d00444-fb19-44dd-a0fc-61ad4b16b74e
19/02/18 09:39:57 [main]: WARN session.SessionState: METASTORE_FILTER_HOOK will be ignored, since hive.security.authorization.manager is set to instance of HiveAuthorizerFactory.
19/02/18 09:39:59 [main]: WARN util.DriverDataSource: Registered driver with driverClassName=org.apache.derby.jdbc.EmbeddedDriver was not found, trying direct instantiation.
19/02/18 09:39:59 [main]: WARN util.DriverDataSource: Registered driver with driverClassName=org.apache.derby.jdbc.EmbeddedDriver was not found, trying direct instantiation.
19/02/18 09:40:00 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:00 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:00 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:00 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:00 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:00 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:01 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:01 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:01 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:01 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:01 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
19/02/18 09:40:01 [main]: WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored
Connected to: Apache Hive (version 3.1.1)
Driver: Hive JDBC (version 3.1.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.1 by Apache Hive
0: jdbc:hive2://>