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

答复: 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 发送时间:

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

Regarding hiveserver2 connection from python

Hi, I am trying to connect to hiveserver2 from python, and i have tried steps as mentioned here : https://cwiki.apache.org/confluence/display/Hive/ Setting+Up+HiveServer2#SettingUpHiveServer2-PythonClientDriver. I am not able to connect to it. I was getting sasl issues, so i changed the