Re: Error when #2 Step: Redistribute Flat Hive Table - File does not exist

2016-12-21 Thread ShaoFeng Shi
BTW: KYLIN-2165 will handle this in a more elegant way, it will be released in next version; 2016-12-22 9:21 GMT+08:00 ShaoFeng Shi : > "java.io.FileNotFoundException: File does not exist: > /young/kylin_test/kylin_metadata_test/kylin-678266c0-ba0e- > 48b4-bdb5-6e578320375a/row_count/00_0" >

Re: Error when #2 Step: Redistribute Flat Hive Table - File does not exist

2016-12-21 Thread ShaoFeng Shi
"java.io.FileNotFoundException: File does not exist: /young/kylin_test/kylin_metadata_test/kylin-678266c0- ba0e-48b4-bdb5-6e578320375a/row_count/00_0" Seems be the issue in https://issues.apache.org/jira/browse/KYLIN-2159 It should be fixed in 1.6.0; could you please check whether there is any

Re: Joint and Order in RowKey

2016-12-21 Thread Alberto Ramón
yes, but I understand that if (ID , TXT) are Joint Dim, In drag and drop you should see together like one Dim 2016-12-21 11:24 GMT+01:00 Li Yang : > Maybe I didn't get the question. But the order of rowkey is adjustable by > drag then move up and down... > > On Tue, Dec 20, 2016 at 2:46 AM, Alber

Re: Joint and Order in RowKey

2016-12-21 Thread Li Yang
Maybe I didn't get the question. But the order of rowkey is adjustable by drag then move up and down... On Tue, Dec 20, 2016 at 2:46 AM, Alberto Ramón wrote: > If we have these columns: > [image: Imágenes integradas 1] > > With There Joints: > [image: Imágenes integradas 3] > > *Why I cant orde

Re: if can add where clause to a measure?

2016-12-21 Thread ShaoFeng Shi
Kylin can do this (by defining "price" as dimension) but the cube explosion rate might be high since "price"'s cardinality is high; Usually when face such a scenario we can optimize it in this way: 1. define a hive view, adding another column say "price_grade"; normalizing the price values into g

Re: How to workaround with columns with NULL value?

2016-12-21 Thread ShaoFeng Shi
Thanks Alberto on question 1, that's a known issue, we can prioritize it if more people comment on it. About 2, if the cardinality of that column isn't high, you can add it to dimension to get this capacity. If it is high, suggest you do a conversion, e.g, 0, 100, 200,...; you can do this easily w