Return-Path: 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 39E7C18098 for ; Sun, 6 Dec 2015 01:25:11 +0000 (UTC) Received: (qmail 94962 invoked by uid 500); 6 Dec 2015 01:25:11 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 94930 invoked by uid 500); 6 Dec 2015 01:25:11 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 94915 invoked by uid 99); 6 Dec 2015 01:25:11 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Dec 2015 01:25:11 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id F2AE12C14F0 for ; Sun, 6 Dec 2015 01:25:10 +0000 (UTC) Date: Sun, 6 Dec 2015 01:25:10 +0000 (UTC) From: "AF (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-4164) ExtractHeader option causing load issues with Drill Explorer MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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: 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)