[
https://issues.apache.org/jira/browse/SPARK-21079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16048246#comment-16048246
]
Maria commented on SPARK-21079:
-------------------------------
[~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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
