[jira] [Comment Edited] (KYLIN-3996) postgresql can not to be used to construct the flat hive table in NO.1 step in building cube via datasourcedefaultSdk
[ https://issues.apache.org/jira/browse/KYLIN-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16849659#comment-16849659 ] haijiandu edited comment on KYLIN-3996 at 5/28/19 11:57 PM: ok,finally it is done. the method is that after kylin.source.default=16,reboot kylin, then to construct the new project , relevant model and cube instead of using previous old project when kylin.source.default=8. was (Author: duhj2): 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: > - > > > > > > > > > > > is there a method to solve it? > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3996) postgresql can not to be used to construct the flat hive table in NO.1 step in building cube via datasourcedefaultSdk
[ 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: > - > > > > > > > > > > > is there a method to solve it? > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[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 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: - is there a method to solve it? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
