First of all, Kylin is pre-calculate OLAP system, that mean it only support query with pre-built cubes.
Any query will fail if there's no cube, or for your #2 question, also will fail when query columns which do not included in any cube. for #3 select * is just same result, please use any aggregation function say group by any column. #4, Kylin do not support merge result from such case, please use one cube definition and run incremental build to put all data in one cube. #5 merge is for admin to manage and optimize HBase storage, not for query. Please let's know if you have any other questions. Thanks Luke Best Regards! --------------------- Luke Han 2015-04-05 6:20 GMT+08:00 Priyanka Laddha <[email protected]>: > Hi, > > i have some questions. > > 1) I loaded hive table then if i want to do query on that table (without > building cube) then it is saying table does not exist. So my question is > can any hive table be queried without building cube. > > 2) I created a cube then i used dimension (suppose x) for cube and if i am > querying hive table's other column which is not dimension then it is not > working. It is giving error column does not found in SQL query. So Can not > we query the column which is not part of dimension of the cube > > 3) Event after building cube select * from hive_test is not working. not > giving data as present in hive_table > > 4) I built 2 cubes on different partition on same hive table then i wrote > query which needs merging of these 2 cubes but i am not getting result > after merging. > > 5) When i clicked on cube there is an option to merge when i clicked it > says no segment to merge. please guide me on merge. > > I am using binary package of Apache Kylin(0.7-SNAPSHOT) > > please help in this. > > Thanks > > Priyanka >
