Re: Hive ORC tables and empty lookup tables in the cube

Hello Xiaoxiang Yu! I'm run same sql query in Hive CLI (beeline) and Kylin. The results is different and correct in Hive CLI. Thanks for the help, and I will create a bug-report in JIRA. WBR, Vadym Antsut -- Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: Hive ORC tables and empty lookup tables in the cube

Hi Antsut, Sorry for my late reply. First let's make it clear, you have two cubes (let us call them cube1 and cube2), cube1 's lookup table is in ORC format and cube2's lookup table is in parquet format. Now you find that with the same sql query, result by cube1 is correct and result by cube2

Re: Hive ORC tables and empty lookup tables in the cube

Hello Xiaoxiang Yu! Thanks for reply! 1. I'm selecting in kylin insight gui from lookup table or from fact table with join to lookup table. All values from lookup table are empty. 2. I'm create in hive the same tables (name with

Re: Hive ORC tables and empty lookup tables in the cube

Hi, Vadym Antsut 1. "The cube builded successfully, but all lookup tables is empty." How do you know your lookup tables is empty? Is it empty in Hive or in Kylin? 2. " I build the cube on the hive parquet tables in model " Does that means you drop you previous table, and create a

Hive ORC tables and empty lookup tables in the cube

Hello! Can anyone help me with a problem: I have in Hive one fact table and few lookup tables in the model for kylin cube. The cube builded successfully, but all lookup tables is empty. If I build the cube on the hive parquet tables in model with the same values, then the lookup tables are not