thanks for reporting the bug, https://issues.apache.org/jira/browse/KYLIN-905 I've fixed it in 0.7-staging, and you'll get this issue fixed in the coming 0.7.3 release. As a workaround you can now use string type for the boolean first.(you might need hive view to adapt boolean columns to string types)
On Fri, Jul 24, 2015 at 1:05 PM, Abhishek Sinha <[email protected]> wrote: > 0.7.1 > > *Abhishek Sinha* > > > *Infoworks.ioMobile : +919035191078* > > On Fri, Jul 24, 2015 at 7:30 AM, hongbin ma <[email protected]> wrote: > > > what is the version you're using? we can try to fix it > > > > On Fri, Jul 24, 2015 at 9:46 AM, Li Yang <[email protected]> wrote: > > > > > Em, smells like a bug. Haven't tested boolean a lot. > > > > > > On Thu, Jul 23, 2015 at 9:39 PM, Abhishek Sinha <[email protected] > > > > > wrote: > > > > > > > exception while executing query: java.lang.String cannot be cast to > > > > java.lang.Boolean > > > > > > > > Query: SELECT "ORDERDETAILS"."ORDERID", "PRODUCTS"."DISCONTINUED", > > > > SUM("FACTTABLE".UNITPRICE) FROM > "0B4C4DB484C5BB3AEC45A397"."FACTTABLE" > > > > INNER JOIN "0B4C4DB484C5BB3AEC45A397"."ORDERDETAILS" ON > > > > ("FACTTABLE"."ORDERDETAILS_FKEY" = > "ORDERDETAILS"."ORDERDETAILS_PKEY") > > > > INNER JOIN "0B4C4DB484C5BB3AEC45A397"."PRODUCTS" ON > > > > ("FACTTABLE"."PRODUCTS_FKEY" = "PRODUCTS"."PRODUCTS_PKEY") GROUP BY > > > > "ORDERDETAILS"."ORDERID", "PRODUCTS"."DISCONTINUED" > > > > > > > > OrderID: Int > > > > Discontinued: Boolean > > > > UnitPrice: Double > > > > > > > > > > > > Any help on this? > > > > > > > > > > > > Regards, > > > > > > > > *Abhishek Sinha* > > > > > > > > > > > > > > > -- > > Regards, > > > > *Bin Mahone | 马洪宾* > > Apache Kylin: http://kylin.io > > Github: https://github.com/binmahone > > > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
