[jira] [Created] (KYLIN-4914) Failed to query "select * from {fact_table}" if a fact table used in two different cubes
xue lin created KYLIN-4914: -- Summary: Failed to query "select * from {fact_table}" if a fact table used in two different cubes Key: KYLIN-4914 URL: https://issues.apache.org/jira/browse/KYLIN-4914 Project: Kylin Issue Type: Bug Components: Query Engine Affects Versions: v3.0.2 Reporter: xue lin Steps to reproduce: 1. Create one model only use one fact table 2. Create two cubes with the same models, they have different dimensions and measures, one cube measures contain COUNT_DISTINCT(return type : bitmap)the other cube measures containEXTENDED_COLUMN (return type : extendedcolumn(100)) and build the 2 cubes 3. Run query with "select * from {fact_table} " with the 2 cubes in ready status, it should be failed with exception message like " No model found for OLAPContext, CUBE_NOT_CONTAIN_ALL_COLUMN[1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_ID], CUBE_NOT_CONTAIN_ALL_COLUMN[1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_STATUS_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_SOURCE_TYPE_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_TYPE_NAME, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUB_AR_RESOURCE_TYPE_NAME, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_TYPE_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_REGION, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_COMPANY_NAME, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_SALE_AREA, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_PROTOCOL_TYPE_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.RATE_BILLING_CYCLE_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.MAIN_AR_RESOURCE_TYPE_NAME, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_PRESENT_SOURCE_TYPE, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.ACTUAL_DAY_AMOUNT, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_TYPE, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_ADDRESS_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_STATUS_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_TYPE_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_PROTOCOL_TYPE, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.DAY_AMOUNT, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_SOURCE_TYPE, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.SUBSCRIBER_BUSINESS_NAME, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.PBO_PRESENT_SOURCE_TYPE_ID, 1_8e4ee38:BOSS_DATABUS.MIRROR_DATABUS_SUBSCRIPTIONFEE.CUSTOMER_CREATE_CHANNEL_NAME], rel#2656421:OLAPTableScan.OLAP.[](table=[BOSS_DATABUS, MIRROR_DATABUS_SUBSCRIPTIONFEE],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33]) while executing SQL: "select * from MIRROR_DATABUS_SUBSCRIPTIONFEE limit 10" -- This message was sent by Atlassian Jira (v8.3.4#803005)
Re: select * from fact_table
Cool Xiaoyu! Best Regards! - Luke Han On Wed, Jun 8, 2016 at 10:57 AM, Li Yang <liy...@apache.org> wrote: > Yeah~~ Thanks Xiaoyu! > > On Sun, Jun 5, 2016 at 8:47 PM, 王晓雨 <wangxiao...@jd.com> wrote: > > > I add a document about RAW measure. > > see: > > http://kylin.apache.org/blog/2016/05/29/raw-measure-in-kylin/ > > > > 在 2016年5月26日,11:08,王晓雨 <wangxiao...@jd.com<mailto:wangxiao...@jd.com>> > 写道: > > > > Comming soon! > > > > 在 2016年05月26日 11:02, Mars J 写道: > > I'm looking forward the documents too~ > > > > 2016-05-26 9:48 GMT+08:00 赵天烁 <zhaotians...@meizu.com > zhaotians...@meizu.com>>: > > > > Waiting for the release note~ > > > > - > > > > 赵天烁 > > Kevin Zhao > > Java工程师 > > 研发中心-Flyme-大数据-平台研发 > > + 86 18826908281 | zhaotians...@meizu.com<mailto:zhaotians...@meizu.com> > > > > 珠海市魅族科技有限公司 > > MEIZU Technology Co., Ltd. > > 广东省珠海市科技创新海岸魅族科技楼 > > MEIZU Tech Bldg., Technology & Innovation Coast > > Zhuhai, 519085, Guangdong, China > > > > > > meizu.com<http://meizu.com> > > > > > > > > -邮件原件- > > 发件人: lidong [mailto:lid...@apache.org] > > 发送时间: 2016年5月26日 9:48 > > 收件人: dev@kylin.apache.org > > 主题: Re: 答复: select * from fact_table > > > > It’s under voting currently. > > > > > > > http://apache-kylin.74782.x6.nabble.com/VOTE-Release-apache-kylin-1-5-2-release-candidate-3-td4672.html > > If the vote got passed in 72 hrs, the binary release will roll out soon. > > > > > > Thanks, > > Dong > > > > > > Original Message > > Sender:赵天烁zhaotians...@meizu.com > > Recipient:dev@kylin.apache.org...@kylin.apache.org > > Date:Thursday, May 26, 2016 09:21 > > Subject:答复: select * from fact_table > > > > > > Seems like already, > > https://github.com/apache/kylin/releases/tag/kylin-1.5.2 > > ----- 赵天烁 Kevin Zhao > > Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com > > 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech > Bldg., > > Technology Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com > > -邮件原件- 发件人: Mars J [mailto:xujiao.myc...@gmail.com] 发送时间: > > 2016年5月26日 9:16 收件人: dev@kylin.apache.org 主题: Re: select * from > > fact_table when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang > > liy...@apache.org: The coming 1.5.2 release has this fixed. Before > that, > > please specify the aggregation function or use group by clause. On > Wed, > > May 18, 2016 at 3:16 PM, Mars J xujiao.myc...@gmail.com wrote:Hello > > all, after build a cube , using the sql select * from fact_table, it > > will not return actual fact table data but rather the follow one,I > have > > define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID > > and DIMC_ID are dimension columns defined in model dimensions step. > > Why 'select * from fact_table' doesn't return real fact data ? how to > > query the all fact data ? > > > > > > > > >
Re: select * from fact_table
Yeah~~ Thanks Xiaoyu! On Sun, Jun 5, 2016 at 8:47 PM, 王晓雨 <wangxiao...@jd.com> wrote: > I add a document about RAW measure. > see: > http://kylin.apache.org/blog/2016/05/29/raw-measure-in-kylin/ > > 在 2016年5月26日,11:08,王晓雨 <wangxiao...@jd.com<mailto:wangxiao...@jd.com>> 写道: > > Comming soon! > > 在 2016年05月26日 11:02, Mars J 写道: > I'm looking forward the documents too~ > > 2016-05-26 9:48 GMT+08:00 赵天烁 <zhaotians...@meizu.com zhaotians...@meizu.com>>: > > Waiting for the release note~ > > - > > 赵天烁 > Kevin Zhao > Java工程师 > 研发中心-Flyme-大数据-平台研发 > + 86 18826908281 | zhaotians...@meizu.com<mailto:zhaotians...@meizu.com> > > 珠海市魅族科技有限公司 > MEIZU Technology Co., Ltd. > 广东省珠海市科技创新海岸魅族科技楼 > MEIZU Tech Bldg., Technology & Innovation Coast > Zhuhai, 519085, Guangdong, China > > > meizu.com<http://meizu.com> > > > > -邮件原件- > 发件人: lidong [mailto:lid...@apache.org] > 发送时间: 2016年5月26日 9:48 > 收件人: dev@kylin.apache.org > 主题: Re: 答复: select * from fact_table > > It’s under voting currently. > > > http://apache-kylin.74782.x6.nabble.com/VOTE-Release-apache-kylin-1-5-2-release-candidate-3-td4672.html > If the vote got passed in 72 hrs, the binary release will roll out soon. > > > Thanks, > Dong > > > Original Message > Sender:赵天烁zhaotians...@meizu.com > Recipient:dev@kylin.apache.org...@kylin.apache.org > Date:Thursday, May 26, 2016 09:21 > Subject:答复: select * from fact_table > > > Seems like already, > https://github.com/apache/kylin/releases/tag/kylin-1.5.2 > - 赵天烁 Kevin Zhao > Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com > 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., > Technology Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com > -邮件原件- 发件人: Mars J [mailto:xujiao.myc...@gmail.com] 发送时间: > 2016年5月26日 9:16 收件人: dev@kylin.apache.org 主题: Re: select * from > fact_table when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang > liy...@apache.org: The coming 1.5.2 release has this fixed. Before that, > please specify the aggregation function or use group by clause. On Wed, > May 18, 2016 at 3:16 PM, Mars J xujiao.myc...@gmail.com wrote:Hello > all, after build a cube , using the sql select * from fact_table, it > will not return actual fact table data but rather the follow one,I have > define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID > and DIMC_ID are dimension columns defined in model dimensions step. > Why 'select * from fact_table' doesn't return real fact data ? how to > query the all fact data ? > > > >
Re: select * from fact_table
I add a document about RAW measure. see: http://kylin.apache.org/blog/2016/05/29/raw-measure-in-kylin/ 在 2016年5月26日,11:08,王晓雨 <wangxiao...@jd.com<mailto:wangxiao...@jd.com>> 写道: Comming soon! 在 2016年05月26日 11:02, Mars J 写道: I'm looking forward the documents too~ 2016-05-26 9:48 GMT+08:00 赵天烁 <zhaotians...@meizu.com<mailto:zhaotians...@meizu.com>>: Waiting for the release note~ - 赵天烁 Kevin Zhao Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com<mailto:zhaotians...@meizu.com> 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology & Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com<http://meizu.com> -邮件原件- 发件人: lidong [mailto:lid...@apache.org] 发送时间: 2016年5月26日 9:48 收件人: dev@kylin.apache.org 主题: Re: 答复: select * from fact_table It’s under voting currently. http://apache-kylin.74782.x6.nabble.com/VOTE-Release-apache-kylin-1-5-2-release-candidate-3-td4672.html If the vote got passed in 72 hrs, the binary release will roll out soon. Thanks, Dong Original Message Sender:赵天烁zhaotians...@meizu.com Recipient:dev@kylin.apache.org...@kylin.apache.org Date:Thursday, May 26, 2016 09:21 Subject:答复: select * from fact_table Seems like already, https://github.com/apache/kylin/releases/tag/kylin-1.5.2 - 赵天烁 Kevin Zhao Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com -邮件原件- 发件人: Mars J [mailto:xujiao.myc...@gmail.com] 发送时间: 2016年5月26日 9:16 收件人: dev@kylin.apache.org 主题: Re: select * from fact_table when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang liy...@apache.org: The coming 1.5.2 release has this fixed. Before that, please specify the aggregation function or use group by clause. On Wed, May 18, 2016 at 3:16 PM, Mars J xujiao.myc...@gmail.com wrote:Hello all, after build a cube , using the sql select * from fact_table, it will not return actual fact table data but rather the follow one,I have define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID and DIMC_ID are dimension columns defined in model dimensions step. Why 'select * from fact_table' doesn't return real fact data ? how to query the all fact data ?
Re: 答复: 答复: select * from fact_table
Comming soon! 在 2016年05月26日 11:02, Mars J 写道: I'm looking forward the documents too~ 2016-05-26 9:48 GMT+08:00 赵天烁 <zhaotians...@meizu.com>: Waiting for the release note~ - 赵天烁 Kevin Zhao Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology & Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com -邮件原件- 发件人: lidong [mailto:lid...@apache.org] 发送时间: 2016年5月26日 9:48 收件人: dev@kylin.apache.org 主题: Re: 答复: select * from fact_table It’s under voting currently. http://apache-kylin.74782.x6.nabble.com/VOTE-Release-apache-kylin-1-5-2-release-candidate-3-td4672.html If the vote got passed in 72 hrs, the binary release will roll out soon. Thanks, Dong Original Message Sender:赵天烁zhaotians...@meizu.com Recipient:dev@kylin.apache.org...@kylin.apache.org Date:Thursday, May 26, 2016 09:21 Subject:答复: select * from fact_table Seems like already, https://github.com/apache/kylin/releases/tag/kylin-1.5.2 - 赵天烁 Kevin Zhao Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com -邮件原件- 发件人: Mars J [mailto:xujiao.myc...@gmail.com] 发送时间: 2016年5月26日 9:16 收件人: dev@kylin.apache.org 主题: Re: select * from fact_table when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang liy...@apache.org: The coming 1.5.2 release has this fixed. Before that, please specify the aggregation function or use group by clause. On Wed, May 18, 2016 at 3:16 PM, Mars J xujiao.myc...@gmail.com wrote:Hello all, after build a cube , using the sql select * from fact_table, it will not return actual fact table data but rather the follow one,I have define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID and DIMC_ID are dimension columns defined in model dimensions step. Why 'select * from fact_table' doesn't return real fact data ? how to query the all fact data ?
Re: 答复: 答复: select * from fact_table
I'm looking forward the documents too~ 2016-05-26 9:48 GMT+08:00 赵天烁 <zhaotians...@meizu.com>: > Waiting for the release note~ > > - > > 赵天烁 > Kevin Zhao > Java工程师 > 研发中心-Flyme-大数据-平台研发 > + 86 18826908281 | zhaotians...@meizu.com > > 珠海市魅族科技有限公司 > MEIZU Technology Co., Ltd. > 广东省珠海市科技创新海岸魅族科技楼 > MEIZU Tech Bldg., Technology & Innovation Coast > Zhuhai, 519085, Guangdong, China > > > meizu.com > > > > -邮件原件- > 发件人: lidong [mailto:lid...@apache.org] > 发送时间: 2016年5月26日 9:48 > 收件人: dev@kylin.apache.org > 主题: Re: 答复: select * from fact_table > > It’s under voting currently. > > http://apache-kylin.74782.x6.nabble.com/VOTE-Release-apache-kylin-1-5-2-release-candidate-3-td4672.html > If the vote got passed in 72 hrs, the binary release will roll out soon. > > > Thanks, > Dong > > > Original Message > Sender:赵天烁zhaotians...@meizu.com > Recipient:dev@kylin.apache.org...@kylin.apache.org > Date:Thursday, May 26, 2016 09:21 > Subject:答复: select * from fact_table > > > Seems like already, > https://github.com/apache/kylin/releases/tag/kylin-1.5.2 > - 赵天烁 Kevin Zhao > Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com > 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., > Technology Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com > -邮件原件- 发件人: Mars J [mailto:xujiao.myc...@gmail.com] 发送时间: > 2016年5月26日 9:16 收件人: dev@kylin.apache.org 主题: Re: select * from > fact_table when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang > liy...@apache.org: The coming 1.5.2 release has this fixed. Before that, > please specify the aggregation function or use group by clause. On Wed, > May 18, 2016 at 3:16 PM, Mars J xujiao.myc...@gmail.com wrote:Hello > all, after build a cube , using the sql select * from fact_table, it > will not return actual fact table data but rather the follow one,I have > define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID > and DIMC_ID are dimension columns defined in model dimensions step. > Why 'select * from fact_table' doesn't return real fact data ? how to > query the all fact data ? >
答复: 答复: select * from fact_table
Waiting for the release note~ - 赵天烁 Kevin Zhao Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology & Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com -邮件原件- 发件人: lidong [mailto:lid...@apache.org] 发送时间: 2016年5月26日 9:48 收件人: dev@kylin.apache.org 主题: Re: 答复: select * from fact_table It’s under voting currently. http://apache-kylin.74782.x6.nabble.com/VOTE-Release-apache-kylin-1-5-2-release-candidate-3-td4672.html If the vote got passed in 72 hrs, the binary release will roll out soon. Thanks, Dong Original Message Sender:赵天烁zhaotians...@meizu.com Recipient:dev@kylin.apache.org...@kylin.apache.org Date:Thursday, May 26, 2016 09:21 Subject:答复: select * from fact_table Seems like already, https://github.com/apache/kylin/releases/tag/kylin-1.5.2 - 赵天烁 Kevin Zhao Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com -邮件原件- 发件人: Mars J [mailto:xujiao.myc...@gmail.com] 发送时间: 2016年5月26日 9:16 收件人: dev@kylin.apache.org 主题: Re: select * from fact_table when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang liy...@apache.org: The coming 1.5.2 release has this fixed. Before that, please specify the aggregation function or use group by clause. On Wed, May 18, 2016 at 3:16 PM, Mars J xujiao.myc...@gmail.com wrote:Hello all, after build a cube , using the sql select * from fact_table, it will not return actual fact table data but rather the follow one,I have define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID and DIMC_ID are dimension columns defined in model dimensions step. Why 'select * from fact_table' doesn't return real fact data ? how to query the all fact data ?
Re: 答复: select * from fact_table
It’s under voting currently. http://apache-kylin.74782.x6.nabble.com/VOTE-Release-apache-kylin-1-5-2-release-candidate-3-td4672.html If the vote got passed in 72 hrs, the binary release will roll out soon. Thanks, Dong Original Message Sender:赵天烁zhaotians...@meizu.com Recipient:dev@kylin.apache.org...@kylin.apache.org Date:Thursday, May 26, 2016 09:21 Subject:答复: select * from fact_table Seems like already, https://github.com/apache/kylin/releases/tag/kylin-1.5.2 - 赵天烁 Kevin Zhao Java工程师 研发中心-Flyme-大数据-平台研发 + 86 18826908281 | zhaotians...@meizu.com 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com -邮件原件- 发件人: Mars J [mailto:xujiao.myc...@gmail.com] 发送时间: 2016年5月26日 9:16 收件人: dev@kylin.apache.org 主题: Re: select * from fact_table when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang liy...@apache.org: The coming 1.5.2 release has this fixed. Before that, please specify the aggregation function or use group by clause. On Wed, May 18, 2016 at 3:16 PM, Mars J xujiao.myc...@gmail.com wrote:Hello all, after build a cube , using the sql select * from fact_table, it will not return actual fact table data but rather the follow one,I have define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID and DIMC_ID are dimension columns defined in model dimensions step. Why 'select * from fact_table' doesn't return real fact data ? how to query the all fact data ?
Re: select * from fact_table
when 1.5.2 release ? 2016-05-22 13:28 GMT+08:00 Li Yang <liy...@apache.org>: > The coming 1.5.2 release has this fixed. Before that, please specify the > aggregation function or use group by clause. > > On Wed, May 18, 2016 at 3:16 PM, Mars J <xujiao.myc...@gmail.com> wrote: > > > Hello all, > > after build a cube , using the sql select * from fact_table, it will > > not return actual fact table data but rather the follow one,I have > define 3 > > measure include count/min/raw > > > > [image: 内嵌图片 1] > > > > DIMA_ID and DIMC_ID are dimension columns defined in model dimensions > step. > > > > Why 'select * from fact_table' doesn't return real fact data ? how to > > query the all fact data ? > > >
select * from fact_table
Hello all, after build a cube , using the sql select * from fact_table, it will not return actual fact table data but rather the follow one,I have define 3 measure include count/min/raw [image: 内嵌图片 1] DIMA_ID and DIMC_ID are dimension columns defined in model dimensions step. Why 'select * from fact_table' doesn't return real fact data ? how to query the all fact data ?