Hello everyone, A query is not working for me sel...
# troubleshooting
b
Hello everyone, A query is not working for me select * from table_name ORDER BY column1 limit 2000 It's breaking somewhere after 1500, getting some merging issues. Seems recently some schema migration has been done, but older data and new data have diff dimensions,so db is unable to merge final result-set. So throwing some merging error Getting this error... [ { "errorCode": 500, "message": "MergeResponseError:\nData schema mismatch between merged block: [adUnitTypeId(STRING)........] and block to merge: [adUnitTypeId(STRING).....], drop block to merge" } ]
x
Changing field type is backward incompatible schema change. It could cause problem when merging results from multiple segments (the issue you came into here), In order to apply backward incompatible schema change, you need to create a new table and re-bootstrap the data.
👍 1