[jira] [Commented] (CARBONDATA-408) Unable to create view from a table

["Anurag Srivastava (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CARBONDATA-408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15747470#comment-15747470 ] 

Anurag Srivastava commented on CARBONDATA-408:
----------------------------------------------

This is not a bug, Carbon data currently does not support View.

> 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)