You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Maria (JIRA)" <ji...@apache.org> on 2017/06/13 19:25:00 UTC
[jira] [Issue Comment Deleted] (SPARK-21079) ANALYZE TABLE fails to
calculate totalSize for a partitioned table
[ https://issues.apache.org/jira/browse/SPARK-21079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maria updated SPARK-21079:
--------------------------
Comment: was deleted
(was: [~ZenWzh], I'm using partitioned table created by Hive. The data is stored in DWRF (ORC) format on HDFS.
Location URI for the table in Metastore is this:
hdfs://dfs47.data.facebook.com:9000/namespace/di/warehouse/b854ac4c8c5045ac877a89d98a8ef7c5/19f337645c2b4fc58b36c488b16d0781'
Location URI for a partition:
hdfs://dfs41.data.facebook.com:9000/namespace/di/warehouse/b854ac4c8c5045ac877a89d98a8ef7c5/e6f3fc1e087f40aa9dc807fcf264cf45/ds=2017-05-17
Notice that table-level path is not a prefix for a partition path: 19f337645... vs e6f3fc1e087...)
> ANALYZE TABLE fails to calculate totalSize for a partitioned table
> ------------------------------------------------------------------
>
> Key: SPARK-21079
> URL: https://issues.apache.org/jira/browse/SPARK-21079
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.1
> Reporter: Maria
> Labels: easyfix
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> ANALYZE TABLE table COMPUTE STATISTICS invoked for a partition table produces totalSize = 0.
> AnalyzeTableCommand fetches table-level storage URI and calculated total size of files in the corresponding directory recursively. However, for partitioned tables, each partition has its own storage URI which may not be a subdirectory of the table-level storage URI.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org