Hi Yang,



------------------ ???????? ------------------
??????: "Li Yang";<[email protected]>;
????????: 2015??12??25??(??????) ????10:10
??????: "user"<[email protected]>; 

????: 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 <[email protected]> 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 ?

Reply via email to