[GDCBDE][2019-05-12 09:25:40] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3] [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache [GDCBDE][2019-05-12 09:25:40] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 17 for SQL Serv... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Connection created on 37.251.139.87 [GDCBDE][2019-05-12 09:25:40] LOGfile: /var/www/html/api/_godrive_dat [GDCBDE][2019-05-12 09:25:40] Work folder: [/var/www/html/api/_godrive_data] [GDCBDE][2019-05-12 09:25:40] INIT DATA EXPLORER v0.1.1 [GDCBDE][2019-05-12 09:25:40] Setup predictors and raw data repo... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Co..] ... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Saving to [../SELECT_TOP_1000000_FROM_Codes_.csv]... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Dataset loaded: 0.01MB in 0.1s(0.0m) 134 rows [GDCBDE][2019-05-12 09:25:40] Loaded 134 predictors [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-12 09:25:40] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN'] [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ca..] ... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Saving to [..e/SELECT_TOP_1000000_FROM_Cars_.csv]... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 118 rows [GDCBDE][2019-05-12 09:25:40] Loaded 118 cars [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ac..] ... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Saving to [..LECT_TOP_1000000_FROM_Accounts_.csv]... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2019-05-12 09:25:40] Loaded 3 accounts [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 118 rows [GDCBDE][2019-05-12 09:25:40] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID'] [GDCBDE][2019-05-12 09:25:40] Done data preparation. [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ra..] ... [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:25:40] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Dataset loaded: 68.66MB in 38.8s(0.6m) 1000000 rows [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ac..] ... [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ca..] ... [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 118 rows [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Co..] ... [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ca..] ... [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Check connection [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Connection ok [GDCBDE][2019-05-12 09:26:19] [SQLHLP] Dataset loaded: 0.02MB in 0.0s(0.0m) 519 rows [GDCBDE][2019-05-12 09:26:19] ....Trying to associate code and description columns to df_rawdata_toshow [GDCBDE][2019-05-12 09:26:20] Finished associating columns [GDCBDE][2019-05-12 13:59:32] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-05-12 13:59:32] [SQLHLP] Check connection [GDCBDE][2019-05-12 13:59:32] [SQLHLP] Connection ok [GDCBDE][2019-05-12 13:59:32] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows [GDCBDE][2019-05-12 22:59:06] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-05-12 22:59:06] [SQLHLP] Check connection [GDCBDE][2019-05-12 22:59:06] [SQLHLP] Connection ok [GDCBDE][2019-05-12 22:59:06] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ... [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ... [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:14] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ... [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ... [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Downloading data [SELECT * FROM Users WHERE Adre..] ... [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Downloading data [SELECT * FROM Accounts WHERE I..] ... [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Downloading data [SELECT * FROM Cars WHERE Accou..] ... [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:15] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2019-05-13 12:19:22] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-05-13 12:19:22] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:19:22] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:19:22] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows