[GDCBDE][2018-10-05 13:26:19] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3] [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache [GDCBDE][2018-10-05 13:26:19] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 17 for SQL Serv... [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Connection created on 37.251.139.87 [GDCBDE][2018-10-05 13:26:19] LOGfile: /var/www/html/api/_godrive_dat [GDCBDE][2018-10-05 13:26:19] Work folder: [/var/www/html/api/_godrive_data] [GDCBDE][2018-10-05 13:26:19] INIT DATA EXPLORER v0.1.1 [GDCBDE][2018-10-05 13:26:19] Setup predictors and raw data repo... [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Loading file [..ata/db_cache/SELECT_FROM_Codes_.csv] ... [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows [GDCBDE][2018-10-05 13:26:19] Loaded 134 predictors [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ... [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Check connection [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Connection ok [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2018-10-05 13:26:19] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN'] [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Loading file [..data/db_cache/SELECT_FROM_Cars_.csv] ... [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 56 rows [GDCBDE][2018-10-05 13:26:19] Loaded 56 cars [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Loading file [../db_cache/SELECT_FROM_Accounts_.csv] ... [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2018-10-05 13:26:19] Loaded 3 accounts [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ... [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Check connection [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Connection ok [GDCBDE][2018-10-05 13:26:19] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 60 rows [GDCBDE][2018-10-05 13:26:19] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID'] [GDCBDE][2018-10-05 13:26:19] Done data preparation. [GDCBDE][2018-10-05 13:26:19] Sampling 2 data of size [10000], all_cars=True, cars_ids=[[]]... [GDCBDE][2018-10-05 13:26:19] Selecting all cars ... [GDCBDE][2018-10-05 13:26:19] Sampling 0/2 for car:10 [GDCBDE][2018-10-05 13:26:19] Sampling data [10000]... [GDCBDE][2018-10-05 13:28:42] Done sampling data. [GDCBDE][2018-10-05 13:28:42] Saving raw data ... [GDCBDE][2018-10-05 13:28:42] [SQLHLP] SaveTable size 0.68670654296875 [GDCBDE][2018-10-05 13:28:42] [SQLHLP] SAVING TABLE [APPEND](10,000 records 0.69MB)... [GDCBDE][2018-10-05 13:28:42] [SQLHLP] Check connection [GDCBDE][2018-10-05 13:28:42] [SQLHLP] Connection ok [GDCBDE][2018-10-05 13:28:47] [SQLHLP] DONE SAVE TABLE. Time = 5.1s (0.09min) [GDCBDE][2018-10-05 13:28:47] Done saving raw data. [GDCBDE][2018-10-05 13:28:47] Sampling 1/2 for car:41 [GDCBDE][2018-10-05 13:28:47] Sampling data [10000]... [GDCBDE][2018-10-05 13:31:09] Done sampling data. [GDCBDE][2018-10-05 13:31:09] Saving raw data ... [GDCBDE][2018-10-05 13:31:09] [SQLHLP] SaveTable size 0.68670654296875 [GDCBDE][2018-10-05 13:31:09] [SQLHLP] SAVING TABLE [APPEND](10,000 records 0.69MB)... [GDCBDE][2018-10-05 13:31:09] [SQLHLP] Check connection [GDCBDE][2018-10-05 13:31:09] [SQLHLP] Connection ok [GDCBDE][2018-10-05 13:31:14] [SQLHLP] DONE SAVE TABLE. Time = 4.5s (0.07min) [GDCBDE][2018-10-05 13:31:14] Done saving raw data. [GDCBDE][2018-10-05 13:31:14] Data sampling for 2 data of size [10000] finished in 294.9s