Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4164

ExtractHeader option causing load issues with Drill Explorer

    XMLWordPrintableJSON

    Details

      Description

      When the extractHeader setting is set to true ("extractHeader": true,) in the storage configurations options (for dfs and s3a plugins) any attempt to load the csv (i.e. click on the file in the drill explorer) results in the unhandled exception error:

      "Column 'columns' does not belong to table Table."

      Full extract of the error below.

      Exception Text **************
      System.ArgumentException: Column 'columns' does not belong to table Table.
      at System.Data.DataRow.GetDataColumn(String columnName)
      at DrillExplorer.DRExploreTablesDialog.RetrieveCSVMetadata(String schemaName, String path)
      at DrillExplorer.DRExploreTablesDialog.BrowseDfsNode(DRTreeNode dfsNode)
      at DrillExplorer.DRExploreTablesDialog.browseTreeView_AfterSelect(Object sender, TreeViewEventArgs e)
      at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
      at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
      at System.Windows.Forms.TreeView.WmNotify(Message& m)
      at System.Windows.Forms.TreeView.WndProc(Message& m)
      at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

      Loaded Assemblies **************
      mscorlib
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
      CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
      ----------------------------------------
      DrillExplorer
      Assembly Version: 1.2.0.0
      Win32 Version: 1.2.0.0
      CodeBase: file:///C:/Program%20Files/MapR%20Drill%20ODBC%20Driver/lib/DrillExplorer.exe
      ----------------------------------------
      System.Windows.Forms
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
      ----------------------------------------
      System
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
      ----------------------------------------
      System.Drawing
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.93.0 built by: NETFXREL2STAGE
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
      ----------------------------------------
      System.Configuration
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
      ----------------------------------------
      System.Core
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
      ----------------------------------------
      System.Xml
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
      ----------------------------------------
      System.Data
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
      ----------------------------------------
      System.Transactions
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
      ----------------------------------------
      System.EnterpriseServices
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
      ----------------------------------------
      System.Numerics
      Assembly Version: 4.0.0.0
      Win32 Version: 4.6.79.0 built by: NETFXREL2
      CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
      ----------------------------------------

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              aj8907 AF
            • Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: