Did you re-generate the system cube's metadata after add the configuration "kylin.metrics.prefix=db_rft_rcmo_rfda" in the kylin.properties?
http://kylin.apache.org/docs23/howto/howto_setup_systemcube.html At 2018-04-04 17:59:53, "Kumar, Manoj H" <manoj.h.ku...@jpmorgan.com> wrote: Its not working even though I have set up the properties. In jSON file, I have given the DB name db_rft_rcmo_rfda. Why its creating DB name as Kylin? How can we change it & make it configurable Hive DB name. -bash-4.1$ ls -ltr total 20 -rw------- 1 a_rcmo_nd a_rcmo_grp 1976 Apr 2 08:59 db_rft_rcmo_rfda.HIVE_METRICS_QUERY_QA.json -rw------- 1 a_rcmo_nd a_rcmo_grp 2480 Apr 2 09:00 db_rft_rcmo_rfda.HIVE_METRICS_QUERY_CUBE_QA.json -rw------- 1 a_rcmo_nd a_rcmo_grp 1863 Apr 2 09:00 db_rft_rcmo_rfda.HIVE_METRICS_QUERY_RPC_QA.json -rw------- 1 a_rcmo_nd a_rcmo_grp 2306 Apr 2 09:01 db_rft_rcmo_rfda.HIVE_METRICS_JOB_QA.json -rw------- 1 a_rcmo_nd a_rcmo_grp 1624 Apr 2 09:01 db_rft_rcmo_rfda.HIVE_METRICS_JOB_EXCEPTION_QA.json Regards, Manoj From: Kumar, Manoj H Sent: Wednesday, April 04, 2018 3:10 PM To: 'user@kylin.apache.org' <user@kylin.apache.org> Subject: RE: Re:RE: kylin 2.3.1 - System Cube Tables Thanks for the input.. Let me try it out & I will update you. Regards, Manoj From: Ma Gang [mailto:mg4w...@163.com] Sent: Wednesday, April 04, 2018 2:30 PM To:user@kylin.apache.org Subject: Re:RE: kylin 2.3.1 - System Cube Tables Hi Manoj, You can configure it using "kylin.metrics.prefix" configuration in the kylin.properties file. Maybe it is better to use "DEFAULT" for this configuration by default. At 2018-04-02 22:26:56, "Kumar, Manoj H" <manoj.h.ku...@jpmorgan.com> wrote: Can it be possible to create the table in project Database as we don’t have permission to create new databasesKYLIN? How can we use the same hive DB used for Kylin Cube? Is there any way to change it? Pls. advise. Regards, Manoj This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited. This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.