Bigquery: Error In Split() Returns

I have a table TabA in BigQuery which has a column ColA and the column ColA has the following structure 1038627|21514184 and the table TabA has more than a million records. I use

Solution 1:

is it the problem with the data or the problem with the split ??

To help in troubleshooting - I would recommend running same logic in BigQuery Standard SQL

#standardSQL
SELECT 
  ColA,
  SPLIT(ColA, '|')[SAFE_OFFSET(0)] AS part1,
  SPLIT(ColA, '|')[SAFE_OFFSET(1)] AS part2
FROM TabA