Return-Path: 
 <issues-return-23725-apmail-drill-issues-archive=drill.apache.org@drill.apache.org>
X-Original-To: apmail-drill-issues-archive@minotaur.apache.org
Delivered-To: apmail-drill-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id CE67317468
	for <apmail-drill-issues-archive@minotaur.apache.org>;
 Mon, 21 Sep 2015 06:21:04 +0000 (UTC)
Received: (qmail 65723 invoked by uid 500); 21 Sep 2015 06:21:04 -0000
Delivered-To: apmail-drill-issues-archive@drill.apache.org
Received: (qmail 65288 invoked by uid 500); 21 Sep 2015 06:21:04 -0000
Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.apache.org>
List-Post: <mailto:issues@drill.apache.org>
List-Id: <issues.drill.apache.org>
Reply-To: dev@drill.apache.org
Delivered-To: mailing list issues@drill.apache.org
Received: (qmail 65245 invoked by uid 99); 21 Sep 2015 06:21:04 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Sep 2015 06:21:04 +0000
Date: Mon, 21 Sep 2015 06:21:04 +0000 (UTC)
From: "Daniel Barclay (Drill) (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12895048.1442816443000.25316.1442816464406@Atlassian.JIRA>
In-Reply-To: <JIRA.12895048.1442816443000@Atlassian.JIRA>
References: <JIRA.12895048.1442816443000@Atlassian.JIRA>
 <JIRA.12895048.1442816443149@arcas>
Subject: [jira] [Created] (DRILL-3814) Directory containing only
 unrecognized files reported as not found vs. taken as empty table
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394

Daniel Barclay (Drill) created DRILL-3814:
---------------------------------------------

             Summary: Directory containing only unrecognized files reported as not found vs. taken as empty table
                 Key: DRILL-3814
                 URL: https://issues.apache.org/jira/browse/DRILL-3814
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser, Storage - Other
            Reporter: Daniel Barclay (Drill)
            Assignee: Aman Sinha


A directory subtree all of whose descendent files have unrecognized extensions is reported as non-existent rather treated as a table with zero rows.

Is this intended? 

(The error message is the exact same error message that results if the user gets a directory name wrong and refers to a non-existent directory, making the message really confusing and misleading.)

For example, for directory {{/tmp/unrecognized_files_directory}} containing only file {{/tmp/unrecognized_files_directory/junk.junk}}:

{noformat}
0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`unrecognized_files_directory`;
Sep 20, 2015 11:16:34 PM org.apache.calcite.sql.validate.SqlValidatorException <init>
SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table 'dfs.tmp.unrecognized_files_directory' not found
Sep 20, 2015 11:16:34 PM org.apache.calcite.runtime.CalciteException <init>
SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 19: Table 'dfs.tmp.unrecognized_files_directory' not found
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 19: Table 'dfs.tmp.unrecognized_files_directory' not found


[Error Id: 0ce9ba05-7f62-4063-a2c0-7d2b4f1f7967 on dev-linux2:31010] (state=,code=0)
0: jdbc:drill:zk=local> 
{noformat}

Notice how that is the same message as for a non-existent directory:

{noformat}
0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`no_such_directory`;
Sep 20, 2015 11:17:12 PM org.apache.calcite.sql.validate.SqlValidatorException <init>
SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table 'dfs.tmp.no_such_directory' not found
Sep 20, 2015 11:17:12 PM org.apache.calcite.runtime.CalciteException <init>
SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 19: Table 'dfs.tmp.no_such_directory' not found
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 19: Table 'dfs.tmp.no_such_directory' not found


[Error Id: 49f423f1-5dfe-4435-8b72-78e0b999980e on dev-linux2:31010] (state=,code=0)
0: jdbc:drill:zk=local> 
{noformat}






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)