[ https://issues.apache.org/jira/browse/HIVE-26931?focusedWorklogId=842749&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-842749 ]
ASF GitHub Bot logged work on HIVE-26931: ----------------------------------------- Author: ASF GitHub Bot Created on: 01/Feb/23 04:40 Start Date: 01/Feb/23 04:40 Worklog Time Spent: 10m Work Description: pudidic merged PR #4003: URL: https://github.com/apache/hive/pull/4003 Issue Time Tracking ------------------- Worklog Id: (was: 842749) Time Spent: 40m (was: 0.5h) > 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 > Assignee: Subhasis Gorai > Priority: Major > Labels: pull-request-available > Time Spent: 40m > Remaining Estimate: 0h > > 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)