haijiandu created KYLIN-3996:
--------------------------------
Summary: postgresql can not to be used to construct the flat hive
table in NO.1 step in building cube via datasourcedefaultSdk
Key: KYLIN-3996
URL: https://issues.apache.org/jira/browse/KYLIN-3996
Project: Kylin
Issue Type: Bug
Components: Driver - JDBC
Affects Versions: v2.6.1
Environment: kylin3.0.0+hadoop2.7.4+hive2.1.1+hbase1.2.6
Reporter: haijiandu
Attachments: kylin_log_error_1.jpg, kylin_log_error_2.jpg,
kylin_log_error_3.jpg, kylin_log_error_4.jpg, kylin_log_error_5.jpg,
kylin_properties_duhj.jpg, kylin_sql.jpg, kylin_sqoopToflatHiveTable_Error.jpg,
postgresql_xml.jpg, server_config_kylin_1.jpg, server_config_kylin_1.jpg,
server_config_kylin_2.jpg
postgresql can not to be used to construct the flat hive table in NO.1 step in
building cube via datasourcedefaultSdk. whether in kylin.properties or in
postgresql.xml，corresponding configureations have been finished as required by
official specification.There alwarys occurs a problem such as "ERROR
manager.SqlManager: Error executing statement:
org.postgresql.util.PSQLException:
ERROR: syntax error at or near ".",
when kylin is linked to postgresql databese, it seems that the errors happen in
sql brought by kylin. the sql has back quote,as it is "`" ,that causes query
failure brought by table name and columns defined by back quote(`).
as required, in kylin.properties ,its configuration has been as followings
kylin.source.default=16
kylin.source.jdbc.connection-url=jdbc:postgresql://192.168.75.123:5432/dvdrental
kylin.source.jdbc.driver=org.postgresql.Driver
kylin.source.jdbc.dialect=postgresql
kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.DefaultAdaptor
kylin.source.jdbc.user=postgres
kylin.source.jdbc.pass=1234
kylin.source.jdbc.sqoop-home=/duhj/sqoop-1.4.7.bin__hadoop-2.6.0
kylin.source.jdbc.filed-delimiter=|
kylin.source.jdbc.sqoop-mapper-num=4
what is more, in
~/apache-kylin-3.0/conf/datasource/postgresql.xml，corresponding conf is as
followings:
-<DATASOURCE_DEF DIALECT="postgresql" ID="postgresql" NAME="kylin">
<PROPERTY NAME="sql.default-converted-enabled" VALUE="true"/>
<PROPERTY NAME="sql.allow-no-offset" VALUE="true"/>
<PROPERTY NAME="sql.allow-fetch-no-rows" VALUE="true"/>
<PROPERTY NAME="sql.allow-no-orderby-with-fetch" VALUE="true"/>
<PROPERTY NAME="sql.keyword-default-escape" VALUE="true"/>
<PROPERTY NAME="sql.keyword-default-uppercase" VALUE="true"/>
<PROPERTY NAME="schema.database.black-list-pattern" VALUE="publi.*, edw"/>
<PROPERTY NAME="sql.case-sensitive" VALUE="true"/>
<PROPERTY NAME="metadata.enable-cache" VALUE="true"/>
<PROPERTY NAME="sql.enable-quote-all-identifiers" VALUE="false"/>
is there a method to solve it?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
