I would like to set Kylin 5 Standalone (Docker Version) so that the source data for the models takes from PostgreSQL and not from Hive.
I downloaded the JDBC driver from https://jdbc.postgresql.org/download/postgresql-42.7.3.jar and saved in $SQOOP_HOME/lib and to $KYLIN_HOME/ext (according from https://www.progress.com/tutorials/jdbc/import-data-from-salesforce-and-othe rs-to-apache-kylin-using-jdbc) I set up in Kylin.Properties: kylin.metadata.url=kylin_metadata@jdbc,driverClassName=org.postgresql.Driver ,url= <mailto:kylin.metadata.url=kylin_metadata@jdbc,driverClassName=org.postgresq l.Driver,url=%22jdbc:postgresql://dwh-db-prod:5432/dwh%22,username=mylogin,p assword=mypassword> "jdbc:postgresql://dwh-db-prod:5432/dwh",username=mylogin,password=mypasswor d kylin.source.default=8 kylin.source.jdbc.connection-url=jdbc:postgresql://dwh-db-prod:5432/dwh kylin.source.jdbc.driver=org.postgresql.Driver kylin.source.jdbc.dialect=default kylin.source.jdbc.user=mylogin kylin.source.jdbc.pass=mypassword kylin.source.jdbc.sqoop-home=/usr/hdp/current/sqoop-client kylin.source.default=8 kylin.source.jdbc.filed-delimiter=| and then I restarted Kylin: $KYLIN_HOME/bin/kylin.sh restart I still don't have the PostgreSQL table, but only the demo of the SSB table from Hive. Could anyone advise me what is the right procedure? thank you very much Josef Szylar
