what's the output of executing this command?: hive -e "describe <your_table_name>"
2015-12-25 11:19 GMT+08:00 zz <[email protected]>: > Hi Yang & all, > I checked hive config by "hive -e set" in the server which kylin deployed, > seems nothing wrong. > Then I tried to run sample.sh in kylin/bin , it created tables: > "kylin_cal_dt" "kylin_category_groupings" "kylin_sales" successfully and > I can find these in metastore DB (mysql) . > Need I do some config in kylin.properties to make it load hive table > metadata by hive remote model? I guess some property make it use hive > default Derby . > Below is my hive-site.xml: > > <configuration> > <property> > <name>javax.jdo.option.ConnectionURL</name> > > <value>jdbc:mysql://localhost:3306/metastore?createDatabaseIfNotExist=true</value> > <description>metadata is stored in a MySQL server</description> > </property> > <property> > <name>javax.jdo.option.ConnectionDriverName</name> > <value>com.mysql.jdbc.Driver</value> > <description>MySQL JDBC driver class</description> > </property> > <property> > <name>javax.jdo.option.ConnectionUserName</name> > <value>hive</value> > <description>user name for connecting to mysql server</description> > </property> > <property> > <name>javax.jdo.option.ConnectionPassword</name> > <value>password</value> > <description>password for connecting to mysql server</description> > </property> > <property> > <name>hive.metastore.uris</name> > <value>thrift://10.224.243.127:9083</value> > </property> > <property> > <name>hive.metastore.schema.verification</name> > <value>false</value> > </property> > <property> > <name>hive.metastore.warehouse.dir</name> > <value>/user/hive/warehouse</value> > </property> > <!--<property> > <name>hive.server.thrift.port</name> > <value>10000</value> > </property> --> > </configuration> > > > > > ------------------ 原始邮件 ------------------ > *发件人:* "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 ? >> > > -- Best regards, Shaofeng Shi
