Rejected Data

Naveen_Kumar

 Hi,
when i am running this command
" copy flex_table from 'path' parser fjsonparser() rejectmax 10;"
After getting any invalid data It rollbacks entire data.
I want to reject only invalid data.
Is there any way to do so?

Thanks
Naveen

Rahul_Choudhary

Hi Naveen

This is not possible currently since as per Vertica documentation specifying rejected data and exceptions files is not currently supported while loading flex tables.

Kindly go through below documented link for more info on this:

http://documentation.verticacorp.com/Crane/HTML/#Authoring/FlexTables/UsingFlexTableParsers.htm%3FTo...


Regards
Rahul 

Naveen_Kumar

Thanks rahul,
Above link is not working.
Can you tell me ,is there any alternative way to achieve this.?

Rahul_Choudhary

Unfortunately we don't have any workaround & still have limitation around this.

Kindly check below link once again & let me know if still unable to open the same

https://my.vertica.com/docs/7.0.x/Crane/HTML/#Authoring/FlexTables/UsingFlexTableParsers.htm%3FTocPath%3DFlex%20Tables%20Guide%7C_____5


Regards
Rahul

Naveen_Kumar

Thanks,
but getiing same -
The Page You Requested Cannot Be Found
.

Prasanta_Pal

Try the below one or
Go to my.vertica.com and go to vertica 7.x online documentation and search for Using flex table
https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/FlexTables/UsingFlexTableParsers.htm%3FTo...

Rahul_Choudhary

Hi Naveen

This is not possible currently since as per Vertica documentation specifying rejected data and exceptions files is not currently supported while loading flex tables. Kindly go through below documented link for more info on this: https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/FlexTables/UsingFlexTableParsers.htm%3FTo...

Regards Rahul