You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (JIRA)" <ji...@apache.org> on 2019/07/15 05:14:00 UTC
[jira] [Commented] (SPARK-28364) Unable to read complete data from
an external hive table stored as ORC that points to a managed table's data
files which is getting stored in sub-directories.
[ https://issues.apache.org/jira/browse/SPARK-28364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884859#comment-16884859 ]
Hyukjin Kwon commented on SPARK-28364:
--------------------------------------
Will you be able to make a simple reproducer so that people check and investigate without using azure?
> Unable to read complete data from an external hive table stored as ORC that points to a managed table's data files which is getting stored in sub-directories.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: SPARK-28364
> URL: https://issues.apache.org/jira/browse/SPARK-28364
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.4.0
> Reporter: Debdut Mukherjee
> Priority: Major
> Attachments: pic.PNG
>
>
> Unable to read complete data from an external hive table stored as ORC that points to a managed table's data files (ORC) which is getting stored in sub-directories.
> The count also does not match unless the path is given with a *.
> *Example This works:-*
> "adl://<adls_name>.azuredatalakestore.net/clusters/<cluster path>/hive/warehouse/db2.db/tbl1/*"
> But the above creates a blank directory named ' * ' in ADLS(Azure Data Lake Store) location
>
> The below one does not work when a SELECT COUNT ( * ) is executed on this external table. It gives partial count.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS db1.tbl1 (
> Col_1 string,
> Col_2 string
> STORED AS ORC
> LOCATION "adl://<adls_name>.azuredatalakestore.net/clusters/<cluster path>/hive/warehouse/db2.db/tbl1/"
> )
> {code}
>
> I was looking for a resolution in google, and even adding below lines to the Databricks Notebook did not solve the problem.
> {code}
> sqlContext.setConf("mapred.input.dir.recursive","true");
> sqlContext.setConf("mapreduce.input.fileinputformat.input.dir.recursive","true");
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org