Re: Unexpected behavior when joinning streaming table and hive table

2019-02-17 Thread Chao Long
: "lifan.su"; Date: Wed, Feb 13, 2019 04:30 PM To: "dev"; Subject: Unexpected behavior when joinning streaming table and hive table Hello, I am evaluating Kylin and tried to join streaming table and hive table, but now got unexpected behavior. All the scripts c

[jira] [Created] (KYLIN-3815) Unexpected behavior when joinning streaming table and hive table

2019-02-17 Thread Chao Long (JIRA)
Chao Long created KYLIN-3815: Summary: Unexpected behavior when joinning streaming table and hive table Key: KYLIN-3815 URL: https://issues.apache.org/jira/browse/KYLIN-3815 Project: Kylin

Re: Unexpected behavior when joinning streaming table and hive table

2019-02-14 Thread lifan.su
Thank you for your reply, the gist contains the corresponding model description json file. But not list together with cube. I have updated the gist with timestamp column renamed to epoch to avoid the syntax error during query. But this problem still reproduced. Lifan Su -- Sent from:

Re: Unexpected behavior when joinning streaming table and hive table

2019-02-13 Thread ShaoFeng Shi
Using hour as the partition column should be fine. From the data, it seems the declared column sequence is not matched with the persisted data. Lifan, I see you posted the cube JSON, could you please also provide the model's JSON? That would help to analysis the problem. Thank you! Best regards,

Re: Unexpected behavior when joinning streaming table and hive table

2019-02-13 Thread Xiaoxiang Yu
Hi, lifei After check your model.json, I found you use "HOUR_START" as your partition_date_column, which is not correct. I think you should change to "timestamp" and have another try. Source code at

Unexpected behavior when joinning streaming table and hive table

2019-02-13 Thread lifan.su
Hello, I am evaluating Kylin and tried to join streaming table and hive table, but now got unexpected behavior. All the scripts can be found in https://gist.github.com/OstCollector/a4ac396e3169aa42a416d96db3021195 (may need to modify some script to match the environments) Environment: Centos 7