clickhouse Auto Inference detect String column as Float

[shabir1]

clickhouse Auto Inference detects the String column as Float
I have a String column, Values start with E like

col1
E76565
E76428
E76525
.
.

Clickhouse detects it as Nullable(Float) with all NULL values.

[shabir1]

if c1 column is detected as Float64 then why the value is NaN

CREATE TABLE test2 as format(CSV, 'E876,42.42,Hello World!')
select * from test2

[Avogar]

That's because e876 and similar is valid float in exponential notation:

:) select * from format(CSV, '1E20')

┌────────────────────c1─┐
│ 100000000000000000000 │
└───────────────────────┘

But I think we should infer such values as Strings anyway. I will fix it

[Avogar]

As a workaround you can set a prefferred type for this specific column using setting schema_inference_hints