title: Query tables in Apache Drill without adding in extensions to the table name
body: <p>I have an Apache Drill setup with the following storage plugin </p>
  
  <pre><code>{
    "type": "file",
    "connection": "file:///",
    "config": null,
    "workspaces": {
      "tmp": {
        "location": "/tmp",
        "writable": true,
        "defaultInputFormat": null,
        "allowAccessOutsideWorkspace": false
      },
      "csv": {
        "location": "/home/user/data/csv",
        "writable": false,
        "defaultInputFormat": "csv",
        "allowAccessOutsideWorkspace": false
      },
      "parquet": {
        "location": "/home/user/data/parquet",
        "writable": false,
        "defaultInputFormat": "parquet",
        "allowAccessOutsideWorkspace": false
      }
    },
    "formats": {
      "csv": {
        "type": "text",
        "extensions": [
          "csv"
        ],
        "skipFirstLine": true,
        "extractHeader": true,
        "delimiter": ","
      },
      "parquet": {
        "type": "parquet",
        "autoCorrectCorruptDates": false
      }
    },
    "enabled": true
  }
  </code></pre>
  
  <p>The name has been configured to <code>foo</code>.</p>
  
  <p>The issue is that I wanted to write a query where the name of the table does not have the extension.</p>
  
  <p>I tried the following,</p>
  
  <pre class="lang-sql prettyprint-override"><code>select * from foo.csv.`agency` limit 100
  </code></pre>
  
  <p>I get the following response</p>
  
  <pre><code>org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: From line 1, column 15 to line 1, column 21: Object 'agency' not found within 'foo.csv' [Error Id: 80be4497-b71c-47dd-bc2c-6abfa425d55a on nn-hadoop-1:30112]
  </code></pre>
  
  <p>But this works</p>
  
  <pre class="lang-sql prettyprint-override"><code>select * from foo.csv.`agency.csv` limit 100
  </code></pre>
  
  <p>Is there a way for me to not suffix the table name (file name) with the file extension when I create my query? I have included the <code>defaultInputFormat</code> in the workspace</p>