[
https://issues.apache.org/jira/browse/KYLIN-4442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082027#comment-17082027
]
Sonu Singh commented on KYLIN-4442:
-----------------------------------
Hi Xiaoxiang, there is no error in log. Please find below the log:
2020-04-12 06:43:49,652 INFO [metrics-blocking-reservoir-scheduler-0]
hive.HiveReservoirReporter:124 : Try to write 34 records
2020-04-12 06:43:49,842 WARN [metrics-blocking-reservoir-scheduler-0]
conf.HiveConf:5220 : HiveConf of name hive.enforce.bucketing does not exist
2020-04-12 06:43:49,844 INFO [metrics-blocking-reservoir-scheduler-0]
hive.HiveProducer:113 : For hdfs://dev-2:8020, supportAppend was set to true
2020-04-12 06:43:49,846 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.HiveMetaStoreClient:441 : Trying to connect to metastore with URI
thrift://dev-2:9083
2020-04-12 06:43:49,846 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.HiveMetaStoreClient:517 : Opened a connection to metastore, current
connections: 3
2020-04-12 06:43:49,848 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.HiveMetaStoreClient:570 : Connected to metastore.
2020-04-12 06:43:49,889 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.HiveMetaStoreClient:600 : Closed a connection to metastore, current
connections: 2
2020-04-12 06:43:49,895 DEBUG [metrics-blocking-reservoir-scheduler-0]
hive.HiveProducer:177 : create partition by ALTER TABLE
KYLIN.HIVE_METRICS_JOB_QA ADD IF NOT EXISTS PARTITION (kday_date='2020-04-12').
2020-04-12 06:43:49,933 INFO [metrics-blocking-reservoir-scheduler-0]
SessionState:1227 : Hive Session ID = 5778504d-b220-474e-88d8-fc2f05888d7c
2020-04-12 06:43:49,979 INFO [metrics-blocking-reservoir-scheduler-0]
session.SessionState:790 : Created HDFS directory:
/tmp/hive/root/5778504d-b220-474e-88d8-fc2f05888d7c
2020-04-12 06:43:50,078 INFO [metrics-blocking-reservoir-scheduler-0]
session.SessionState:790 : Created local directory:
/opt/kylin/tomcat/temp/root/5778504d-b220-474e-88d8-fc2f05888d7c
2020-04-12 06:43:50,080 INFO [metrics-blocking-reservoir-scheduler-0]
session.SessionState:790 : Created HDFS directory:
/tmp/hive/root/5778504d-b220-474e-88d8-fc2f05888d7c/_tmp_space.db
2020-04-12 06:43:50,143 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:554 : Compiling
command(queryId=root_20200412064349_ace126be-05e5-451d-8966-1e3fc4e2d5bf):
ALTER TABLE KYLIN.HIVE_METRICS_JOB_QA ADD IF NOT EXISTS PARTITION
(kday_date='2020-04-12')
2020-04-12 06:43:51,694 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.HiveMetaStoreClient:441 : Trying to connect to metastore with URI
thrift://dev-2:9083
2020-04-12 06:43:51,695 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.HiveMetaStoreClient:517 : Opened a connection to metastore, current
connections: 3
2020-04-12 06:43:51,696 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.HiveMetaStoreClient:570 : Connected to metastore.
2020-04-12 06:43:51,696 INFO [metrics-blocking-reservoir-scheduler-0]
metastore.RetryingMetaStoreClient:97 : RetryingMetaStoreClient proxy=class
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=root
(auth:SIMPLE) retries=1 delay=1 lifetime=0
2020-04-12 06:43:51,782 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:285 : Concurrency mode is disabled, not creating a lock manager
2020-04-12 06:43:52,133 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:666 : Semantic Analysis Completed (retrial = false)
2020-04-12 06:43:52,136 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:374 : Returning Hive schema: Schema(fieldSchemas:null,
properties:null)
2020-04-12 06:43:52,141 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:781 : Completed compiling
command(queryId=root_20200412064349_ace126be-05e5-451d-8966-1e3fc4e2d5bf); Time
taken: 2.047 seconds
2020-04-12 06:43:52,141 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:285 : Concurrency mode is disabled, not creating a lock manager
2020-04-12 06:43:52,142 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:2255 : Executing
command(queryId=root_20200412064349_ace126be-05e5-451d-8966-1e3fc4e2d5bf):
ALTER TABLE KYLIN.HIVE_METRICS_JOB_QA ADD IF NOT EXISTS PARTITION
(kday_date='2020-04-12')
2020-04-12 06:43:52,145 INFO [metrics-blocking-reservoir-scheduler-0]
ql.Driver:2531 : Completed executing
command(queryId=root_20200412064349_ace126be-05e5-451d-8966-1e3fc4e2d5bf); Time
taken: 0.004 seconds
2020-04-12 06:43:53,459 INFO [http-nio-7070-exec-9] service.QueryService:368 :
Check query permission in 0 ms.
2020-04-12 06:43:53,460 INFO [Query 61f3303d-0e17-eb65-94d8-1b808c2ded2a-443]
service.QueryService:405 : Using project: ExternalHive
2020-04-12 06:43:53,460 INFO [Query 61f3303d-0e17-eb65-94d8-1b808c2ded2a-443]
service.QueryService:406 : The original query: select * from sales;
2020-04-12 06:43:53,466 INFO [Query 61f3303d-0e17-eb65-94d8-1b808c2ded2a-443]
service.QueryService:642 : The corrected query: select * from (select * from
sales) limit 50000
2020-04-12 06:43:53,605 ERROR [Query 61f3303d-0e17-eb65-94d8-1b808c2ded2a-443]
service.QueryService:533 : Exception while executing query
:
> Kylin System Cube Hive tables not able to update
> -------------------------------------------------
>
> Key: KYLIN-4442
> URL: https://issues.apache.org/jira/browse/KYLIN-4442
> Project: Kylin
> Issue Type: Bug
> Affects Versions: v3.0.0
> Reporter: Sonu Singh
> Priority: Blocker
>
> Kylin System Cube Hive table is not updating. I am using Kylin hadoop3 code
> and running on vanilla hadoop3.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
