[DRILL-2424] Ignore hidden files in directory path

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.7.0
• Fix Version/s: 1.2.0
• Component/s: Storage - JSON, Storage - Text & CSV
• Assignee: Chun Chang
• Reporter: Andries Engelbrecht
• Created: 10/Mar/15 23:32
• Updated: 03/Oct/15 00:29
• Resolved: 22/Sep/15 14:46

Description

When streaming data to the DFS some records can be incomplete during the temporary write phase for the last file(s). These file typically have a different extension like '.tmp' or can be marked hidden with a prefix of '.' .

Querying the directory path will Drill will then cause a query error as some records may not be complete in the temporary files. Having the ability to have Drill ignore hidden files and/or to only read files of designated extension in the workspace will resolve this problem.

Example is using Flume to stream JSON files to a directory structure, the HDFS sink creates .tmp files (can be hidden with . prefix) that contains incomplete JSON objects till the file is closed and the .tmp extension (or prefix) is removed. Attempting to query the directory structure with Drill then results in errors due to the incomplete JSON object(s) in the tmp files.

Issue Links

• Is contained by: DRILL-3535 Drop table support
• is related to: DRILL-1131 Drill should ignore files in starting with . _