Whenever I paste a multi-line query into VSQL (Vertica Analytic Database interactive terminal), between each line I get this message:
ABORT BEGIN COPY DROP EXPLAIN LOCK RESET SAMPLE STORAGE SET TRUNCATE
ALTER COMMENT CREATE END GRANT PREPARE REVOKE SAVEPOINT SHOW UPDATE
Is there any way I can avoid this?
How do I paste a multi-line command in VSQL without the ABORT BEGIN COPY DROP EXPLAIN LOCK war
+2Hey Owen,
This is an interesting issue, I don't think I have even seen this before! Some questions that will help me troubleshoot:
- What version of Vertica are you using?
- What OS are you running VSQL on?
- What program are you copying the query from?
Can you provide a copy/paste from your VSQL terminal window that exhibits this issue? Do you mind sharing the multi-line query you are pasting into VSQL? I am interested to see if we can reproduce this.
- Mitch
This is an interesting issue, I don't think I have even seen this before! Some questions that will help me troubleshoot:
- What version of Vertica are you using?
- What OS are you running VSQL on?
- What program are you copying the query from?
Can you provide a copy/paste from your VSQL terminal window that exhibits this issue? Do you mind sharing the multi-line query you are pasting into VSQL? I am interested to see if we can reproduce this.
- Mitch
https://www.youtube.com/watch?v=bQrK8GpunXw
answered
+2Hi Owen,
The issue is because, you are pasting your code in vsql and this code is containing tab.
Try removing tabs from you SQL and it will run perfectly.
Hope this helps
NC
The issue is because, you are pasting your code in vsql and this code is containing tab.
Try removing tabs from you SQL and it will run perfectly.
Hope this helps
NC
Okay, there seems to be consensus for the cause of my issue.
I'll begin using 4 spaces instead of tab.
Thank you everyone for your quick response.
I'll begin using 4 spaces instead of tab.
Thank you everyone for your quick response.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
