auto datatypes detection |
khaldoun Ateyeh |
2006-03-06 00:00:00 |
i perform a query on a table column that includes integer values. However.
the hxtttext driver interpret the values as String values.
What is the standard behaviour and how can i change it.
Best Regards.
K. Ateyeh
|
Re:auto datatypes detection |
HXTT Support |
2006-03-06 00:00:00 |
|
If you are using CSV, you can use create table ... aColumn int,bColumn varchar(20, ...) sql to define an int column. But we're considering using "auto datatypes detection" now. That function should be availabe in 48 hours. What's your advice? Please let us know.
|
Re:Re:auto datatypes detection |
khaldoun Ateyeh |
2006-03-06 00:00:00 |
Hi,
Thank you for the quicke answer. For my application it is very important to have a good "auto datates detection".
Best Regards.
K. Ateyeh
|
Re:Re:Re:auto datatypes detection |
HXTT Support |
2006-03-06 00:00:00 |
We will do our best. Thanks for your valuable advice.
|
Re:Re:Re:Re:auto datatypes detection |
khaldoun Ateyeh |
2006-03-06 00:00:00 |
Hi,
Please let me know as soon as the function is available.
Best Regards.
K. Ateyeh
|
Re:Re:Re:Re:Re:auto datatypes detection |
HXTT Support |
2006-03-07 00:00:00 |
|
Supported now. Please download the latest package.
|
Re:Re:Re:Re:Re:Re:auto datatypes detection |
khaldoun Ateyeh |
2006-03-07 00:00:00 |
Hi,
Thank you for the very quick answer and for providing the functionality in so short time.
i have a question regarding the new functionality. I noticed that to figure out the type you check the type of the first non-null value. However, in many cases this is troublesome. I.e. in cases where the first non-value is an Integer and the column includes double values.
Best Regards.
Ateyeh
|
Re:Re:Re:Re:Re:Re:Re:auto datatypes detection |
HXTT Supports |
2006-03-07 00:00:00 |
No the fist row. It will check the first 10 rows.
At http://www.hxtt.com/text/installation.html#url .
maxScanRows: Indicates how many rows should be scanned when determining the column types. If you set MaxScanRows to 0, the entire file is scanned. For those tables with predefined table structure, that option will be ignored. Default:10
You can use jdbc:csv:/yourcsppath=maxScanRows=1000 to design a different value,and so on.
|
Re:Re:Re:Re:Re:Re:Re:Re:auto datatypes detection |
HXTT Supports |
2006-03-07 00:00:00 |
|
It will check int,long,double,date,time, and timestampe.
|
Main
webmaster@hxtt.com