Guys,
Could someone please suggest a resolution for the COPY statement error below:
ERROR 2559: Cannot use subquery in expressions within COPY
The problematic line in question is below:
COPY...
,NE_VERSION AS (SELECT NE_VERSION FROM <lookup table> WHERE EMS_NAME = 'xxx')
Regards,
Bugs.
ERROR 2559: Cannot use subquery in expressions within COPY
Moderator: NorbertKrupa
Re: ERROR 2559: Cannot use subquery in expressions within C
Hello,
You cannot use a sybquery inside a COPY statement.
COPY command is bulk loader utility in Vertica which loads the data from files or STDIN. it is not capable of loading data from another table.
Please refer the documentation
https://my.vertica.com/docs/7.0.x/HTML/ ... gLoads.htm
Hope this helps
You cannot use a sybquery inside a COPY statement.
COPY command is bulk loader utility in Vertica which loads the data from files or STDIN. it is not capable of loading data from another table.
Please refer the documentation
https://my.vertica.com/docs/7.0.x/HTML/ ... gLoads.htm
Hope this helps