[ https://issues.apache.org/jira/browse/KYLIN-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16849659#comment-16849659 ]
haijiandu commented on KYLIN-3996: ---------------------------------- ok,finally it is done. the method is that after kylin.source.default=16,reboot kylin, then to construct the new project and relevant model and cube instead of using previous project when kylin.source.default=8. > 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 > Assignee: XiaoXiang Yu > Priority: Critical > Labels: datasource, postgresql, sdk > 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)