cloudant - how to increase the sample size used during schema discovery to 'unlimited'? -
i have encountered errors sdp 1 of potential fixes increase sample size used during schema discovery 'unlimited'.
for more information on these errors, see:
- no matched schema {"_id":"...","doc":{...}
- the value type json field xxxx presented yyyy discovered data type of table's column zzzz
- xxxx not exist in discovered schema. document has not been imported
question:
how can set sample size? after have set sample size, need trigger rescan?
these steps can follow change sample size. beware larger sample size increase runtime algorithm , there no indication in dashboard other job remaining in 'triggered' state while.
verify specific load has been stopped , dashboard status shows stopped (with or without error)
find document
https://<account>.cloudant.com/_warehouser/<source>
<source>
matches name of cloudant database have issues withnote: check
https://<account>.cloudant.com/_warehouser/_all_docs
if document id not obvioussubstitute
"sample_size": null
(which scans sample of 10,000 random documents)"sample_size": -1
(to scan documents in database) or"sample_size": x
(to scan x documents in database x positive integer)
save document , trigger rescan in dashboard. new schema discovery run execute using defined sample size.
Comments
Post a Comment