I ran a query "Select * from fact_Orders". This presented a lot of garbage, The correct column headers, but the contents were extremely random, e.g. blanks in the key column, VAT rates of 12282384234E-45 .
When I export to CSV , it presents fine in the CSV.
When I just select the Order_id and Vat_rate, they present correctly. When I select * a single row, it presents fine.
There seems to be a 'limit' on the number of columns but this varies , I think depending on data_types, but the column count limit seems to be a power of 2 (I have failed at the 4th and the 8th column, depending on which columns are chosen).
So, the data is being presented incorrectly in the databricks interface.
Has anybody else seen this and, more importantly, is there a fix?