You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "rohithsharma (JIRA)" <ji...@apache.org> on 2012/07/31 16:43:33 UTC
[jira] [Commented] (HIVE-3324) analyze command is not gathering
"num_rows" present in the table.
[ https://issues.apache.org/jira/browse/HIVE-3324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13425819#comment-13425819 ]
rohithsharma commented on HIVE-3324:
------------------------------------
>From the code I see, default configuration is for connecting to database is "hive.stats.dbconnectionstring=jdbc:derby:;databaseName=TempStatsStore;create=true".When analyze command is executed, initialy PARTITION_STATS_V2 is created at HIVE JVM whereas statistics publishing is done at YarnChild. While publishing the statistics to database, directly executing inserting data into to table.Since yarn child is different jvm, it doesnot find initially created table PARTITION_STATS_V2.
> analyze command is not gathering "num_rows" present in the table.
> -----------------------------------------------------------------
>
> Key: HIVE-3324
> URL: https://issues.apache.org/jira/browse/HIVE-3324
> Project: Hive
> Issue Type: Bug
> Components: Statistics
> Affects Versions: 0.10.0, 0.9.1
> Reporter: rohithsharma
>
> When analyze command is executed, "collectableStats" i.e num_rows and raw_data_size is always zero even though table contains data.
> bq. [num_partitions: 0, num_files: 1, num_rows: 0, total_size: 5812, raw_data_size: 0]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira