答复: Hive failed with "No files matching path"

2016-07-14 Thread Huang Meilong
Why not output for "echo $sql;"? 发件人: gm yu 发送时间: 2016年7月15日 9:59:39 收件人: user@hive.apache.org 主题: Hive failed with "No files matching path" Hello I have a question about Hive(2.0.0) and HDFS(2.7.2). I met many Hive failure with "No files

答复: Can I specify database name in hive metastore service?

2016-10-25 Thread Huang Meilong
e name to the thrift uri (metastore uri) since HiveServer2 will use the same uri to access metadata regardless of which Hive database is used by the client. I hope this helps, Peter 2016. okt. 25. 17:32 ezt írta ("Huang Meilong" <ims...@outlook.com<mailto:ims...@ou

答复: Can I specify database name in hive metastore service?

2016-10-27 Thread Huang Meilong
; 发送时间: 2016年10月27日 19:06:32 收件人: Huang Meilong 抄送: user@hive.apache.org 主题: Re: Can I specify database name in hive metastore service? Hi Huang, It is possible to use the same Metastore server for 2 HiveServer2 instances, but then the HiveServer2 instances will share the metastore. They wil

Can I specify database name in hive metastore service?

2016-10-25 Thread Huang Meilong
Hi, To use hive metastore service, I must set `javax.jdo.option.ConnectionURL`, `javax.jdo.option.ConnectionDriverName` and `hive.metastore.uris` in hive-site.xml, like this: javax.jdo.option.ConnectionURL

Got NullPointerException when create table specifying location url with hive metastore api

2016-11-25 Thread Huang Meilong
Hi, I'm using hive metastore api(org.apache.hive.hive-metastore-2.1.0.jar) to create table, when I do not specify the location uri, it works fine: ``` HiveConf c = new HiveConf(); c.set("hive.metastore.uris", "thrift://xx.xx.xx.xx:9083");

Difference between MANAGED_TABLE and EXTERNAL_TABLE in org.apache.hadoop.hive.metastore.TableType

2016-12-01 Thread Huang Meilong
Hi all, I found an enum TableType in package org.apache.hadoop.hive.metastore. What's the difference between MANAGED_TABLE and EXTERNAL_TABLE? Will the table be an EXTERNAL TABLE with setting table type EXTERNAL_TABLE when creating table? I found the code to determine whether a table is an

答复: Difference between MANAGED_TABLE and EXTERNAL_TABLE in org.apache.hadoop.hive.metastore.TableType

2016-12-01 Thread Huang Meilong
s when an external table is dropped, the data is not deleted. People often use this as a way to load data into a directory in HDFS and then “cast” a table structure over it by creating an external table with that directory as its location. Alan. > On Dec 1, 2016, at 06:15, Huang Meilong &

What's the 'hive.metastore.fastpath' in hive site for?

2017-01-09 Thread Huang Meilong
Hi all, What's the 'hive.metastore.fastpath' in hive site for?

how can I collect hive metastore metrics and hiveserver2 metrics separately

2018-08-22 Thread Huang Meilong
Hi all, I found the configuration of collecting hive metrics here: https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-Metrics Configuration Properties - Apache Hive - Apache Software