[GDCBDE][2018-10-14 13:34:38] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2018-10-14 13:34:38] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache
[GDCBDE][2018-10-14 13:34:38] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 17 for SQL Serv...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Connection created on 37.251.139.87
[GDCBDE][2018-10-14 13:34:39] LOGfile: /var/www/html/api/_godrive_dat
[GDCBDE][2018-10-14 13:34:39] Work folder: [/var/www/html/api/_godrive_data]
[GDCBDE][2018-10-14 13:34:39] INIT DATA EXPLORER v0.1.1
[GDCBDE][2018-10-14 13:34:39] Setup predictors and raw data repo...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Loading file [..e/SELECT_TOP_500000_FROM_Codes_.csv] ...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2018-10-14 13:34:39] Loaded 134 predictors
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:34:39] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN']
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Loading file [..he/SELECT_TOP_500000_FROM_Cars_.csv] ...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 120 rows
[GDCBDE][2018-10-14 13:34:39] Loaded 120 cars
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Loading file [..ELECT_TOP_500000_FROM_Accounts_.csv] ...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:34:39] Loaded 3 accounts
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 120 rows
[GDCBDE][2018-10-14 13:34:39] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2018-10-14 13:34:39] Done data preparation.
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [RawD..] ...
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:34:39] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Dataset loaded: 34.33MB in 17.8s(0.3m) 500000 rows
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Cars..] ...
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 120 rows
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Code..] ...
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:34:56] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:34:57] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows
[GDCBDE][2018-10-14 13:34:57] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Cars..] ...
[GDCBDE][2018-10-14 13:34:57] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:34:57] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:34:57] [SQLHLP] Dataset loaded: 0.02MB in 0.0s(0.0m) 519 rows
[GDCBDE][2018-10-14 13:34:57] ....Trying to associate code and description columns to df_rawdata_toshow
[GDCBDE][2018-10-14 13:34:57] Finished associating columns
[GDCBDE][2018-10-14 13:35:17] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:35:17] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:35:17] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:35:18] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:37:02] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:37:16] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:38:46] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:41:36] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:48:30] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:48:30] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:48:30] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:48:30] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:48:31] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:50:29] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:50:29] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:29] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:29] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:30] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:50:45] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:50:45] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:45] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:45] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:46] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:50:55] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:50:55] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:55] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:55] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:56] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:50:59] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:50:59] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:50:59] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:50:59] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ...
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Downloading data [SELECT TOP 500000 * FROM [Acco..] ...
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Check connection
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Connection ok
[GDCBDE][2018-10-14 13:51:00] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows