[
https://issues.apache.org/jira/browse/DRILL-4164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
AF updated DRILL-4164:
----------------------
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:
bq. "Column 'columns' does not belong to table Table."
Full extract of the error
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
----------------------------------------
was:
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:
bq. "Column 'columns' does not belong to table Table."
Full extract of the error
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
----------------------------------------
> ExtractHeader option causing load issues with Drill Explorer
> ------------------------------------------------------------
>
> Key: DRILL-4164
> URL: https://issues.apache.org/jira/browse/DRILL-4164
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill, Storage - Text & CSV
> Affects Versions: 1.3.0
> Reporter: AF
> Labels: csv, drill
>
> 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:
> bq. "Column 'columns' does not belong to table Table."
> Full extract of the error
> 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
> ----------------------------------------
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
