Can any one faced issue while fetching data from external table. We are copying data from upstream system into our storage S3. As part of copy, directories along with Zero bytes files are been copied. Source File Format is in JSON format and Compress (Gz) . Below is Folder
DATE --> <Folder>
<DAY=201803250> ---> Folder
1.json.gz --> File
<DAY=201803250> ---> Empty Zero Bytes Files.
Please find below screenshot
We are trying to create external table with JSON Serde.