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

Chen Luo commented on ASTERIXDB-2364:
-------------------------------------

I think the correct grammar should be `test`.`employee` instead of 
`test.employee`?

`xxx` is used for resolving conflict names/characters. In this case, 
`test.employee` is simply treated as one identifier, instead of two

> Insert statement doesn't recognize the dataverse in full dataset name
> ---------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2364
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2364
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Xikui Wang
>            Priority: Minor
>
> drop  dataverse test if exists;
> create  dataverse test;
> create type test.Emp as
>  closed {
>   id : integer,
>   fname : string,
>   lname : string,
>   age : integer,
>   dept : string
> };
> create  dataset test.employee(Emp) primary key id;
> create  index idx_employee_first_name  on test.employee (fname) type btree;
> insert into test.employee
> select element {'id':(x.id + 
> 10000),'fname':x.fname,'lname':x.lname,'age':x.age,'dept':x.dept}
> from  `test.employee` as x
> ;
> This fails.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to