kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "haijiandu (JIRA)" <j...@apache.org>
Subject [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
Date Wed, 08 May 2019 02:41:00 GMT
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)

Mime
View raw message