[jira] [Created] (KYLIN-5602) Added logs related to Segment Pruning for derived dimension queries

2023-07-02 Thread huangsheng (Jira)
huangsheng created KYLIN-5602: - Summary: Added logs related to Segment Pruning for derived dimension queries Key: KYLIN-5602 URL: https://issues.apache.org/jira/browse/KYLIN-5602 Project: Kylin

[jira] [Created] (KYLIN-2030) lookup table support group by primary key when no derived dimension

2016-09-19 Thread Zhong,Jason (JIRA)
Zhong,Jason created KYLIN-2030: -- Summary: lookup table support group by primary key when no derived dimension Key: KYLIN-2030 URL: https://issues.apache.org/jira/browse/KYLIN-2030 Project: Kylin

Re: derived dimension

2016-01-07 Thread ShaoFeng Shi
GMT+08:00 Zhang, Zhong : > > > > > > > > > Hi Hongbin, > > > > > > > > > > For the table "KYLIN_CAL_DT", the primary key is "CAL_DT" and > > > > > The foreign_key is "PART_DT". > > > > &g

Re: derived dimension

2016-01-07 Thread zhong zhang
t; > Hi Hongbin, > > > > > > > > For the table "KYLIN_CAL_DT", the primary key is "CAL_DT" and > > > > The foreign_key is "PART_DT". > > > > > > > > For the table "KYLIN_CATEGORY_GROUPINGS&

Re: derived dimension

2016-01-07 Thread ShaoFeng Shi
foreign key > > > Is "LEAF_CATEG_ID" and "LSTG_SITE_ID". > > > > > > Best regards, > > > Zhong > > > > > > -Original Message- > > > From: Zhang, Zhong [mailto:zzh...@cardlytics.com] > > > Sent: Th

Re: derived dimension

2016-01-07 Thread zhong zhang
OUPINGS", the primary > > Key is "LEAF_CATEG_ID" and "SITE_ID", the foreign key > > Is "LEAF_CATEG_ID" and "LSTG_SITE_ID". > > > > Best regards, > > Zhong > > > > -Original Message- > > From: Zhang, Zhong [

Re: derived dimension

2016-01-07 Thread ShaoFeng Shi
nce both the foreign key and "WEEK_BEG_DT" are in the cube and > "WEEK_BEG_DT" can be derived from the foreign key, we mark the column > "WEEK_BEG_DT" as a derived dimension in the UI. The same case happens for > "USER_DEFINED_FIELD1","USER_D

RE: derived dimension

2016-01-07 Thread Zhang, Zhong
" and "LSTG_SITE_ID". Best regards, Zhong -Original Message- From: Zhang, Zhong [mailto:zzh...@cardlytics.com] Sent: Thursday, January 07, 2016 1:53 PM To: dev@kylin.apache.org Subject: RE: derived dimension Hi Hongbin, Thanks so so so ... much for your kind help. The f

RE: derived dimension

2016-01-07 Thread Zhang, Zhong
in the cube and "WEEK_BEG_DT" can be derived from the primary key, we mark the column "WEEK_BEG_DT" as a derived dimension in the UI. I assume the primary key in the table "KYLIN_CAL_DT" is "CAL_DT"? Please help me verify the above two explanations,

Re: derived dimension

2016-01-07 Thread hongbin ma
if the dimension's not explicitly specifying, FK is the column that's derived from. On Thu, Jan 7, 2016 at 11:15 AM, Zhang, Zhong wrote: > Hi All, > > I'm confused by the derived dimension. The following > two sentences are the source that I found online to guide

derived dimension

2016-01-06 Thread Zhang, Zhong
Hi All, I'm confused by the derived dimension. The following two sentences are the source that I found online to guide me use derived dimension. It's kind of unclear to me. Dimensions on lookup table that can be derived by PK. -like User ID derives [Name, Age, Gender] from [1] at page