[jira] [Created] (KYLIN-3996) postgresql can not to be used to construct the flat hive table in NO.1 step in building cube via datasourcedefaultSdk

["haijiandu (JIRA)" <ji...@apache.org>]

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)