You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by zz <zz...@vip.qq.com> on 2015/12/25 04:06:33 UTC
回复: how to load table from hive
Hi Yang,
------------------ 原始邮件 ------------------
发件人: "Li Yang";<li...@apache.org>;
发送时间: 2015年12月25日(星期五) 上午10:10
收件人: "user"<us...@kylin.apache.org>;
主题: Re: how to load table from hive
What matters is the hive-site.xml Kylin picks up. Kylin detects hive config by command `hive -e set`. You can try hive command line on the node where Kylin is deployed and make sure it connects to the desired metastore.
Try diagnose `bin/find-hive-dependency.sh` if you still got problem.
On Fri, Dec 25, 2015 at 9:49 AM, zz <zz...@vip.qq.com> wrote:
Hi Kylin developers,
I'm a newbie for Kylin. Glad to see the excellent OLAP tool. As a Chinese acmen , I like the name.
After I download and run it , I can access the website(http://IP:7070/kylin) and create project successfully . However, when I try to load Hive table, "NoSuchObjectException" alert (Oops...) !
From kylin.log in tomcat , I found some sensitive tracks:
2015-12-24 15:01:16,613 INFO [http-bio-7070-exec-6] metastore.ObjectStore: ObjectStore, initialize called
2015-12-24 15:01:16,926 INFO [http-bio-7070-exec-6] DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored
2015-12-24 15:01:16,927 INFO [http-bio-7070-exec-6] DataNucleus.Persistence: Property hive.metastore.integral.jdo.pushdown unknown - will be ignored
...
2015-12-24 15:01:24,350 INFO [http-bio-7070-exec-6] metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is DERBY
I'm not sure these ignored property is OK or not.
I config Hive as remote mode(use mysql to store metadata, config thrift uris) but kylin try to access DERBY which I do not use !
Could you tell me how to config it ?