ERROR 604 (42P00): Syntax error. Mismatched input. Expecting "RPAREN", got "ffffd72e"

最新推荐文章于 2022-02-11 16:38:12 发布

柔情岁月-万圣节

最新推荐文章于 2022-02-11 16:38:12 发布

阅读量6k

点赞数

CC 4.0 BY-SA版权

分类专栏：问题

本文链接：https://blog.youkuaiyun.com/redhat1986/article/details/102465916

在使用Sqoop将数据从HBase导出到Hive的过程中，遇到了Phoenix的错误ERROR 604 (42P00)：Syntax error. Mismatched input 'ffffd72e'. 解决这个问题的关键在于添加--boundary-query参数，具体解决方案参考链接：https://github.com/forcedotcom/phoenix/wiki/Tuning。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sqoop 导hbase数据到hive

sqoop import  --driver org.apache.phoenix.jdbc.PhoenixDriver  --connect jdbc:phoenix:192.168.35.27,192.168.35.32,192.168.35.33:2181    --query "select *  from \"ods_app_deviceInfo\" where \$CONDITIONS and \"DAYSTR\" ='20190921'"  --hive-table s_evt_sjl_ods_app_eventInfo_i_d  --hive-database stage  --target-dir /user/hive/warehouse/stage.db/s_evt_sjl_ods_app_eventInfo_i_d/20190921  --hive-import  --delete-target-dir  --hive-overwrite  --split-by rowkey  --hive-partition-key dt  --hive-partition-value 20190921

phoenix 报错信息

19/10/09 16:06:57 INFO db.DBInputFormat: Using read commited transaction isolation
19/10/09 16:06:57 INFO mapred.MapTask: Processing split: rowkey >= 'KKKMS耼耲S' AND rowkey < 'X聘聘聙聛쀹쀲\'
19/10/09 16:06:57 INFO db.DBRecordReader: Working on split: rowkey >= 'KKKMS耼耲S' AND rowkey < 'X聘聘聙聛쀹쀲\'
19/10/09 16:06:57 ERROR db.DBRecordReader: Top level exception: 
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Unexpected char: '''
        at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
        at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:118)
        at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1185)
        at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1268)
        at org.apache.phoenix.jdbc.PhoenixPreparedStatement.<init>(PhoenixPreparedStatement.java:94)
        at org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement(PhoenixConnection.java:715)
        at org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement(PhoenixConnection.java:744)
        at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:101)
        at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:235)
        at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:562)
        at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80)
        at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
        at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64)
        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:793)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)
        at org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:270)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Unexpected char: '''
        at org.apache.phoenix.parse.PhoenixSQLLexer.mOTHER(PhoenixSQLLexer.java:4170)
        at org.apache.phoenix.parse.PhoenixSQLLexer.mTokens(PhoenixSQLLexer.java:5234)
        at org.antlr.runtime.Lexer.nextToken(Lexer.java:85)
        at org.antlr.runtime.BufferedTokenStream.fetch(BufferedTokenStream.java:143)
        at org.antlr.runtime.BufferedTokenStream.sync(BufferedTokenStream.java:137)
        at org.antlr.runtime.CommonTokenStream.skipOffTokenChannels(CommonTokenStream.java:113)
        at org.antlr.r