我正在使用ApachePhoenix并尝试创建模式。
以下是使用的版本（psuedo分布式安装）
hadoop-2.6.4版
hbase-1.1.2版
Phoenix城-4.7.0
sqlline-1.1.8版本
zookeper-3.4.6（hbase默认/托管）
我很乐意创建模式
hbase-site.xml文件 <configuration> <property> <name>hbase.rootdir</name> <value>hdfs://{{HOST}}:8020/hbase</value> </property> <property> <name>hbase.zookeeper.property.dataDir</name> <value>/home/testuser/zookeeper</value> </property> <property> <name>hbase.cluster.distributed</name> <value>true</value> </property> <property> <name>hbase.zookeeper.quorum</name> <value>{{HOST}}</value> </property> <property> <name>zookeeper.znode.parent</name> <value>/hbase</value> <source>hbase-site.xml</source> </property> <property> <name>phoenix.schema.isNamespaceMappingEnabled</name> <value>true</value> </property> </configuration> 获取以下错误 `0: jdbc:phoenix:hdp1.hw.com:2181> !tables +
15条答案
按热度按时间6rqinv9w1#
--+
g0czyy6m2#
---+
uklbhaso3#
--+
xoefb8l84#
+---------+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_NA | +
23c0lvtd5#
-----+
ttcibm8c6#
----+
yqkkidmi7#
-----+
whlutmcx8#
----+
amrnrhlw9#
--+
iswrvxsc10#
+---------+ 0: jdbc:phoenix:hdp1.hw.com:2181> create schema test; Error: ERROR 601 (42P00): Syntax error. Encountered "schema" at line 1, column 8. (state=42P00,code=601) org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "schema" at line 1, column 8. at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33) at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111) 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.PhoenixStatement.execute(PhoenixStatement.java:1339) at sqlline.Commands.execute(Commands.java:822) at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:808) at sqlline.SqlLine.begin(SqlLine.java:681) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:292) Caused by: NoViableAltException(98@[]) at org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:650) at org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:500) at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108) ... 9 more
但是使用phoenix 4.14.0` 我能够用相同的配置成功地创建模式。0yycz8jy11#
+---------+ | | SYSTEM | CATALOG | SYSTEM TABLE | | | | | SYSTEM | FUNCTION | SYSTEM TABLE | | | | | SYSTEM | SEQUENCE | SYSTEM TABLE | | | | | SYSTEM | STATS | SYSTEM TABLE | | | +
vu8f3i0k12#
---+
6jygbczu13#
---+
6ss1mwsb14#
-----+
xv8emn3q15#
----+