Skip to main content

Rejected Data

  • April 3, 2014
  • 6 replies
  • 24 views

Naveen_Kumar
Forum|alt.badge.img+1
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

6 replies

Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • April 3, 2014
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
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • April 3, 2014
Thanks rahul,
Above link is not working.
Can you tell me ,is there any alternative way to achieve this.?


Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • April 3, 2014
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
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • April 3, 2014
Thanks,
but getiing same -
The Page You Requested Cannot Be Found
.

Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • April 9, 2014
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
Forum|alt.badge.img
  • Participating Frequently
  • April 14, 2014
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