Re: Re:Kylin GUI error "Cannot get HiveTableMeta" on AWS EMR with Glue as hive metastore

2020-04-10 Thread mvishnubhatta
Great. Thank you. I tried out Kaige's suggestion on
https://issues.apache.org/jira/browse/KYLIN-3685 that you pointed me to and
that worked for me.

--
Sent from: http://apache-kylin.74782.x6.nabble.com/


Re: No tables on KYLIN WEB UI and NoSuchObjectException(message:default.kylin_intermediate_* table not found) when building cube

2020-04-10 Thread Yaqian Zhang
Hi:
If you want to load table from hive to kylin, you should 'sync' hive table in 
Model->Data Source..After 'sync' successfully, the table will show in 
Model->Data Source.But at this time, these tables are only data source. It's 
not precomputed and you can't see it on the insight page.
If you want to query some tables in kylin, you have to create model and cube 
for them and build the cube. After the build job is successful, these tables 
will appear in the insight page.
I'm not sure if I understand you correctly.
You can refer to this ducument:
http://kylin.apache.org/docs/tutorial/create_cube.html 







> 在 2020年4月10日,16:25,xatax  写道:
> 
> Thank you very much for your response Yaqian.
> 
> So, regarding the question where tables are not showing, I tested this.
> 
> I created a hive external table on table data in S3 location (parquet file).
> Then I created another table out of it using CTAS so that the new table is
> part of the same hive database and has storage in hdfs; however even after
> doing that the new tables are not showing in the DEFAULT database which is
> the one I installed with what came with the sample.sh file.
> 
> So, how do I get table available in the Kylin UI for usage when I am adding
> new tables in hive.
> 
> Thanks in advance.
> 
> 
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/



Re: No tables on KYLIN WEB UI and NoSuchObjectException(message:default.kylin_intermediate_* table not found) when building cube

2020-04-10 Thread xatax
Thank you very much for your response Yaqian.

So, regarding the question where tables are not showing, I tested this.

I created a hive external table on table data in S3 location (parquet file).
Then I created another table out of it using CTAS so that the new table is
part of the same hive database and has storage in hdfs; however even after
doing that the new tables are not showing in the DEFAULT database which is
the one I installed with what came with the sample.sh file.

So, how do I get table available in the Kylin UI for usage when I am adding
new tables in hive.

Thanks in advance.


--
Sent from: http://apache-kylin.74782.x6.nabble.com/


[jira] [Created] (KYLIN-4441) Add restart command to kylin.sh

2020-04-10 Thread Yaqian Zhang (Jira)
Yaqian Zhang created KYLIN-4441:
---

 Summary: Add restart command to kylin.sh
 Key: KYLIN-4441
 URL: https://issues.apache.org/jira/browse/KYLIN-4441
 Project: Kylin
  Issue Type: Improvement
  Components: Client - CLI
Affects Versions: all
Reporter: Yaqian Zhang
Assignee: Yaqian Zhang
 Fix For: v3.1.0, v3.0.2, v2.6.6






--
This message was sent by Atlassian Jira
(v8.3.4#803005)