Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Automatic column type inference using sample data #9

Closed
harelba opened this issue Jan 4, 2014 · 4 comments
Closed

Automatic column type inference using sample data #9

harelba opened this issue Jan 4, 2014 · 4 comments

Comments

@harelba
Copy link
Owner

harelba commented Jan 4, 2014

Currently, column types are not inferred, and the sql type treatment is dependent on the expression being used. For example when using sum(c2), c2 will be treated as a number. This sometimes requires converting types as part of the sql statement - For example: ls -dltr * | q "select * from - where cast(c5 as int) > 10000". Automatic type inference can fix that.
@harelba
Copy link
Owner Author

harelba commented Feb 22, 2014

Working on it. Will be released soon.

@harelba
Copy link
Owner Author

harelba commented Mar 1, 2014

Beta version with this feature will be released later on today.

@harelba
Copy link
Owner Author

harelba commented Mar 1, 2014

Beta version 1.3.0b released with this fix. Will close when the version moves out of beta.

@harelba
Copy link
Owner Author

harelba commented Mar 3, 2014

Added new feature in version 1.3.0. Happens automatically during the reading of the input. If you want to see the column name/type analysis results, run q with -A

@harelba harelba closed this as completed Mar 3, 2014
@cemeyer cemeyer mentioned this issue Mar 4, 2014
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@harelba