[ 
https://issues.apache.org/jira/browse/KYLIN-4206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xiaoxiang Yu resolved KYLIN-4206.
---------------------------------
    Resolution: Fixed

Code change merged.

> Build kylin on EMR 5.23. The kylin version is 2.6.4. When building the cube, 
> the hive table cannot be found
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: KYLIN-4206
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4206
>             Project: Kylin
>          Issue Type: Bug
>          Components: Environment 
>    Affects Versions: v2.6.4
>         Environment: EMR 5.23(hadoop 2.8.5\HBase 1.4.9\hive 2.3.4\Spark 
> 2.4.0\Tez 0.9.1\HCatalog 2.3.4\Zookeeper 3.4.13)
> kylin 2.6.4
>            Reporter: rongneng.wei
>            Priority: Major
>             Fix For: v3.1.0
>
>         Attachments: kylin.properties, kylin_hive_conf.xml, kylin_job_conf.xml
>
>
> hi,
>    I  Build kylin on EMR 5.23. The kylin version is 2.6.4.When building the 
> cube, the hive table cannot be found.The detailed error information is as 
> follows:
> java.lang.RuntimeException: java.io.IOException: 
> NoSuchObjectException(message:kylin_flat_db_test1.kylin_intermediate_kylin_sales_cube_4e93b31d_3be2_c9e8_55de_a9814f63c4ba
>  table not found)java.lang.RuntimeException: java.io.IOException: 
> NoSuchObjectException(message:kylin_flat_db_test1.kylin_intermediate_kylin_sales_cube_4e93b31d_3be2_c9e8_55de_a9814f63c4ba
>  table not found) at 
> org.apache.kylin.source.hive.HiveMRInput$HiveTableInputFormat.configureJob(HiveMRInput.java:83)
>  at 
> org.apache.kylin.engine.mr.steps.FactDistinctColumnsJob.setupMapper(FactDistinctColumnsJob.java:126)
>  at 
> org.apache.kylin.engine.mr.steps.FactDistinctColumnsJob.run(FactDistinctColumnsJob.java:104)
>  at 
> org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:131)
>  at 
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:167)
>  at 
> org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71)
>  at 
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:167)
>  at 
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114)
>  at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  at java.lang.Thread.run(Thread.java:748)
> On the EMR, hive metadata is shared by glue, and the URL of Metastore is 
> configured in hive-site.xml.
> <name>hive.metastore.uris</name>
>  <value>thrift://ip-172-40-15-164.ec2.internal:9083</value>
>  <description>JDBC connect string for a JDBC metastore</description>
>  </property>
> <property>
>  <name>hive.metastore.client.factory.class</name>
>  
> <value>com.amazonaws.glue.catalog.metastore.AWSGlueDataCatalogHiveClientFactory</value>
>  </property>
> But when I use hive's own metadata, that is, don't use glue to share 
> metadata, the above exception will not occur, comment out the following 
> configuration.
> <!--<property>
> <name>hive.metastore.client.factory.class</name>
> <value>com.amazonaws.glue.catalog.metastore.AWSGlueDataCatalogHiveClientFactory</value>
> </property>
> -->
> But since EMR uses shared metadata, if you don't use metadata sharing, then I 
> can't query other hive tables built by the cluster.
> The configuration file is detailed in the attachment. Please help me solve 
> this problem.Thank you。
> Best regard.



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

Reply via email to