Subhasis Gorai created HIVE-26931:
-------------------------------------
Summary: REPL LOAD command does not throw any error for incorrect
syntax
Key: HIVE-26931
URL: https://issues.apache.org/jira/browse/HIVE-26931
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: Subhasis Gorai
In some cases, users are using the REPL LOAD command incorrectly. It does not
really throw any meaningful error/warning message, and as expected it does not
replicate the database as well.
For example,
{code:java}
repl load target_db with
('hive.repl.rootdir'='hdfs://c3649-node2.coelab.cloudera.com:8020/user/hive/repl',
'hive.repl.include.external.tables'= 'true',
'hive.repl.replica.external.table.base.dir'='hdfs://c3649node2.coelab.cloudera.com:8020/warehouse/tablespace/external/hive/target_db.db'){code}
The above command does not follow the REPL LOAD syntax. This does not produce
any error message, nor it replicates the database. So, it causes confusion.
{code:java}
0: jdbc:hive2://nightly7x-us-bj-3.nightly7x-u> repl load test_1_replica with
('hive.repl.rootdir'='hdfs://c3649-node2.coelab.cloudera.com:8020/user/repl',
'hive.repl.include.external.tables'= 'true',
'hive.repl.replica.external.table.base.dir'='hdfs://c3649node2.coelab.cloudera.com:8020/warehouse/tablespace/external/hive/test_1_replica.db');
INFO : Compiling
command(queryId=hive_20221201113704_08ee46a6-ede9-4c92-9502-82b9fbc416bd): repl
load test_1_replica with
('hive.repl.rootdir'='hdfs://c3649-node2.coelab.cloudera.com:8020/user/repl',
'hive.repl.include.external.tables'= 'true',
'hive.repl.replica.external.table.base.dir'='hdfs://c3649node2.coelab.cloudera.com:8020/warehouse/tablespace/external/hive/test_1_replica.db')
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null)
INFO : Completed compiling
command(queryId=hive_20221201113704_08ee46a6-ede9-4c92-9502-82b9fbc416bd); Time
taken: 0.051 seconds
INFO : Executing
command(queryId=hive_20221201113704_08ee46a6-ede9-4c92-9502-82b9fbc416bd): repl
load test_1_replica with
('hive.repl.rootdir'='hdfs://c3649-node2.coelab.cloudera.com:8020/user/repl',
'hive.repl.include.external.tables'= 'true',
'hive.repl.replica.external.table.base.dir'='hdfs://c3649node2.coelab.cloudera.com:8020/warehouse/tablespace/external/hive/test_1_replica.db')
INFO : Completed executing
command(queryId=hive_20221201113704_08ee46a6-ede9-4c92-9502-82b9fbc416bd); Time
taken: 0.001 seconds
INFO : OK
No rows affected (0.065 seconds)
0: jdbc:hive2://nightly7x-us-bj-3.nightly7x-u>{code}
Ideally, since this is a wrong command, it should throw an error.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
