carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "SWATI RAO (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-408) Unable to create view from a table
Date Fri, 11 Nov 2016 12:25:58 GMT
SWATI RAO created CARBONDATA-408:
------------------------------------

             Summary: Unable to create view from a table
                 Key: CARBONDATA-408
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-408
             Project: CarbonData
          Issue Type: Bug
            Reporter: SWATI RAO
            Priority: Trivial


When we tried to execute the following query to create view in carbon :

create view emp_view AS Select name,sal from demo2;

NOTE :demo2 table contains following columns: 
id Int,
name String, 
sal decimal

we got the following exception:
Error: org.apache.spark.sql.execution.QueryExecutionException: FAILED: SemanticException [Error
10004]: Line 1:31 Invalid table alias or column reference 'name': (possible column names are:
col) (state=,code=0)

where as we are able to create view in hive using the same query.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message