VERTICA EXPORT COMMAND SHOWS 0 Rows Exported . Why ?
I am trying to export some records from one node (A) to another node (B).
First of assume like the current sys date is 12-09-2016
select datediff(day,'2016-12-03', date(sysdate)); 6
select distinct batch_load_date,count(6) from abc_daily group by batch_load_date order by batch_load_date desc
2016-12-09 00:54:43 18565916
2016-12-08 01:18:02 18521512
2016-12-07 00:49:55 18501251
2016-12-06 00:52:43 18509135
2016-12-05 00:52:49 18517930
2016-12-04 00:52:34 18527800
select * from studio.ABC_DAILY where date_val between date(sysdate-7) and date(sysdate) order by date_val desc limit 20
Output shows as well
NOW WHAT I DID I TRIED to export some records of information from node A table to B node table using export command. So i connected to vsql at NODE B and triggered following query :-
studio > connect to VERTICA TestPulse user studio PASSWORD 'xxxx' on '220.127.116.114', 5433;
studio >connect to VERTICA TESTDB user studio PASSWORD 'xxxxxx' on '18.104.22.1685', 5433;
BUT THE PROBLEM HERE IS WHEN I TRIGGER FOLLOWING QUERY IT SHOWS 0 ROWS.
studio > EXPORT TO VERTICA ABCDb.ABC_DAILY_TEST AS select * from studio.ABC_DAILY where batch_load_date between date(sysdate-7) and date(sysdate);
But if you look at above mentioned NODE A this query does shows an output at node A but while triggering the same query for export at node B it shows rows exported is ZERO WHY ?
select * from studio.ABC_DAILY where batch_load_date between date(sysdate-7) and date(sysdate);
I wonder why its showing 0 rows exported on output whereas everything is correct. Any help will be highly appreciated.