-
Notifications
You must be signed in to change notification settings - Fork 1.2k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Column types assumed as int if first value is a whole number #13
Comments
I think in this case the only way you are going to get the correct result is to create the table with a schema, rather than rely on type inference. There's only so far down the rabbit hole we can go... |
The json is coming out as 1.000 though. I would get that if it looked like {[1, 2.5, 3.4]} etc where the first value is actually an int. |
The magic is here: It tries to guess the types - but it isn't always going to work (especially in js, where we lack the distinction between an int and a float). |
closing, the solution is really to use a schema |
If I have a column consisting of values [1.000, 2.5, 3.562, ...] then the column is interpreted as integer instead of float. A (bad) workaround is to increment the first value in the column by a negligible amount (e.g. 0.00000001).
The text was updated successfully, but these errors were encountered: