答复: 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 matching path". The sc

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 jdbc:mysql://x/hivemeta?createDatabaseIfNotExist=true&characterEncodi

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

2016-10-25 Thread Huang Meilong
rift 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" mailto:ims...@outlook.com>>): Hi, To use hi

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

2016-10-26 Thread Huang Meilong
: Huang Meilong 抄送: user@hive.apache.org 主题: Re: Can I specify database name in hive metastore service? Hi Huang, According to the picture you want to start 2 HiveServer2 instances both with embedded metastore, where the metastore db is stored in the same RDBMS in a different database. This is

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

2016-10-27 Thread Huang Meilong
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 will have the same dat

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"); HiveMetaStoreClien

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
le 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 Mei

HMS connections to meta db

2016-12-13 Thread Huang Meilong
Hi all, Will HMS keep the connection to meta db when HMS is up? Or will HMS build connection to meta db every time the query comes to HMS and release connection to meta db when query finished?

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 ...