Unable to import data from MySQL - DATETIME issue

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Unable to import data from MySQL - DATETIME issue

Benjamin Donnachie

I’m having issues importing data from MySQL and keep getting the error: “Couldn’t read from database: Unknown data type: DATETIME.  Add entry in weka/experiment/DatabaseUtils.props …”.  I have a DatabaseUtils.props file that contains: “DATETIME=9” and can successfully connect to the database:

connecting to: jdbc:<a href="mysql://localhost:3306/DC" class="">mysql://localhost:3306/DC = true
Query: select * from log2timeline where (datetime > "2000/01/01 00:00:01" AND datetime < "2020/12/31 23:59:59");
4197243 rows selected (100 displayed).

Search through the archives has been inconclusive.  I’m using Weka 3.9.4 with MySQL Community Server - GPL v8.0.22 under MacOS 10.15.7.  The dataset is approx ~4m entries from a three year old plaso v1.5.3 (log2timeline) file that I originally tried exporting as a CSV but contained too many errors so exported as 4n6time_sqlite and then imported into MySQL.

Extract from DatabaseUtils.prop:

# JDBC driver (comma-separated list)
jdbcDriver=org.gjt.mm.mysql.Driver
# database URL
jdbcURL=jdbc:<a href="mysql://localhost:3306/DC" class="">mysql://localhost:3306/DC

# specific data types
[…]
# other options
CREATE_DOUBLE=DOUBLE
CREATE_STRING=TEXT
CREATE_INT=INT
CREATE_DATE=DATETIME
DateFormat=yyyy-MM-dd HH:mm:ss
checkUpperCaseNames=false
checkLowerCaseNames=false
checkForTable=true

DATETIME=9
[…]
Any thoughts or help gratefully received!

Many thanks,

Benjamin

_______________________________________________
Wekalist mailing list -- [hidden email]
Send posts to [hidden email]
To unsubscribe send an email to [hidden email]
To subscribe, unsubscribe, etc., visit https://list.waikato.ac.nz/postorius/lists/wekalist.list.waikato.ac.nz
List etiquette: http://www.cs.waikato.ac.nz/~ml/weka/mailinglist_etiquette.html