Mailing-List: contact issues-help@ambari.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ambari.apache.org
Date: Wed, 1 Mar 2017 10:25:45 +0000 (UTC)
From: "Nitiraj Singh Rathore (JIRA)" <jira@apache.org>
To: issues@ambari.apache.org
Message-ID: <JIRA.13046152.1487971039000.28978.1488363945249@Atlassian.JIRA>
In-Reply-To: <JIRA.13046152.1487971039000@Atlassian.JIRA>
References: <JIRA.13046152.1487971039000@Atlassian.JIRA> <JIRA.13046152.1487971039195@jira-lw-us.apache.org>
Subject: [jira] [Updated] (AMBARI-20181) HiveView2.0: Can not create a table
 with space in column name with upload table feature
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 01 Mar 2017 10:25:49 -0000


     [ https://issues.apache.org/jira/browse/AMBARI-20181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nitiraj Singh Rathore updated AMBARI-20181:
-------------------------------------------
    Attachment: AMBARI-20181_branch-2.5.patch

> HiveView2.0: Can not create a table with space in column name with upload table feature
> ---------------------------------------------------------------------------------------
>
>                 Key: AMBARI-20181
>                 URL: https://issues.apache.org/jira/browse/AMBARI-20181
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-views
>    Affects Versions: 2.5.0
>            Reporter: Yesha Vora
>            Assignee: Nitiraj Singh Rathore
>            Priority: Critical
>         Attachments: AMBARI-20181_branch-2.5.patch
>
>
> Scenario:
> * Go to HiveView
> * Go to table tab
> * Click on Upload table
> * Upload a CSV file such that it column name has a space in it. 
> * Click on create table.
> The table creation failed because it does not add `` in the column name where it has space or other special chars. 
> Currently, table creation is failing with below error.
> {code}
> org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:56 Invalid table alias or column reference 'Issue': (possible column names are: summary, issue key, issue id, parent id, issue type, status, project key, project name, project type, project lead, project description, project url, priority, resolution, assignee, reporter, creator, affects version, fix versions, component, labels){code}


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)