Re: Creating Index and no performance improvements

thank you for your answer by the way this is explain commands out: EXPLAIN select AVG(dryBulbTempF) FROM testindex WHERE ndate = '20070710'; OK STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree:

Re: Creating Index and no performance improvements

Long answer An EXTERNAL TABLE in hive is a stub for table in Hive metastore. Data is not managed by Hive and it is an HDFS concern. For that reason if you drop an EXTERNAL table in Hive you just drop references for that table in Hive metastore. Data is not deleted. The conventional indexes don'

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

Because I have many clusters and I want to manage all these clusters' meta data with one metastore, and make the clusters' meta data isolated from each other. Maybe I could create a hive JIRA. Thank you all the same. 发件人: Peter Vary 发送时间: 2016年10月27日 19:06:32 收件

Re: Creating Index and no performance improvements

Have you checked running SQL with EXPLAIN EXTENDED SELECT .. And post the results. In general your compact index will not work HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Creating Index and no performance improvements

Hi guys, I created table and index on this table. Also after I alter that index with rebuild option. But still can't see performance improvements. Only, I can see performance improvements when I query to index table. I used following commands : CREATE EXTERNAL TABLE testindex(wban INT, ndate ST

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 databases and tables. As far as I know it is not possible for a metastore to serve different data for different HiveServer