Apr  6 12:28:59 ip-10-111-0-54 DMLProc[20885]: 59.381462 |0|0|0| I 20 CAL0002: DMLProc has been told to rollback all DML transactions.
Apr  6 12:29:24 ip-10-111-0-54 IDBFile[4396]: 24.835489 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:29:25 ip-10-111-0-54 StorageManager[29145]: SessionManager Caught Signal 15
Apr  6 12:29:25 ip-10-111-0-54 StorageManager[29145]: Shutdown StorageManager...
Apr  6 12:29:25 ip-10-111-0-54 StorageManager[29145]: Ownership: releasing ownership of data1
Apr  6 12:29:25 ip-10-111-0-54 StorageManager[29145]: StorageManager Shutdown Complete.
Apr  6 12:29:40 ip-10-111-0-54 controllernode[28844]: 40.943162 |0|0|0| E 29 CAL0000: DBRM: error: SessionManager::getSystemState() failed (network)
Apr  6 12:31:48 ip-10-111-0-54 StorageManager[5133]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:48 ip-10-111-0-54 StorageManager[5133]: S3Storage: S3 connectivity & permissions are OK
Apr  6 12:31:48 ip-10-111-0-54 StorageManager[5133]: max_concurrent_downloads = 21
Apr  6 12:31:48 ip-10-111-0-54 StorageManager[5133]: max_concurrent_uploads = 21
Apr  6 12:31:48 ip-10-111-0-54 StorageManager[5133]: StorageManager started.
Apr  6 12:31:48 ip-10-111-0-54 StorageManager[5133]: SessionManager waiting for sockets.
Apr  6 12:31:48 ip-10-111-0-54 StorageManager[5128]: StorageManager main process has started
Apr  6 12:31:49 ip-10-111-0-54 StorageManager[5149]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:49 ip-10-111-0-54 StorageManager[5150]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:49 ip-10-111-0-54 StorageManager[5133]: Ownership: taking ownership of data1
Apr  6 12:31:49 ip-10-111-0-54 StorageManager[5160]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:49 ip-10-111-0-54 StorageManager[5171]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:49 ip-10-111-0-54 IDBFile[5190]: 49.902369 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:50 ip-10-111-0-54 StorageManager[5195]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:50 ip-10-111-0-54 StorageManager[5200]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:50 ip-10-111-0-54 IDBFile[5205]: 50.135921 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:50 ip-10-111-0-54 workernode[5205]: 50.158068 |0|0|0| I 30 CAL0000: WorkerNode main process has started
Apr  6 12:31:50 ip-10-111-0-54 StorageManager[5209]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:50 ip-10-111-0-54 StorageManager[5220]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:50 ip-10-111-0-54 StorageManager[5225]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:50 ip-10-111-0-54 StorageManager[5230]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:50 ip-10-111-0-54 StorageManager[5238]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:51 ip-10-111-0-54 StorageManager[5245]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:51 ip-10-111-0-54 StorageManager[5253]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:51 ip-10-111-0-54 StorageManager[5259]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:51 ip-10-111-0-54 StorageManager[5265]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:51 ip-10-111-0-54 StorageManager[5271]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:51 ip-10-111-0-54 StorageManager[5278]: Using the config file found at /etc/columnstore/storagemanager.cnf
Apr  6 12:31:52 ip-10-111-0-54 IDBFile[5292]: 52.234333 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:52 ip-10-111-0-54 controllernode[5292]: 52.257266 |0|0|0| D 29 CAL0000: DBRM Controller: Connected to DBRM_Worker1
Apr  6 12:31:52 ip-10-111-0-54 controllernode[5292]: 52.258004 |0|0|0| D 29 CAL0000: DBRM Controller: Connected to DBRM_Worker2
Apr  6 12:31:52 ip-10-111-0-54 controllernode[5292]: 52.259740 |0|0|0| D 29 CAL0000: DBRM Controller: Connected to DBRM_Worker3
Apr  6 12:31:52 ip-10-111-0-54 controllernode[5290]: 52.260843 |0|0|0| I 29 CAL0000: ControllerNode main process has started
Apr  6 12:31:52 ip-10-111-0-54 IDBFile[5309]: 52.365557 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:52 ip-10-111-0-54 ExeMgr[5424]: 52.540990 |0|0|0| I 16 CAL0008: Success
Apr  6 12:31:52 ip-10-111-0-54 IDBFile[5453]: 52.620646 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:52 ip-10-111-0-54 writeengineserver[5447]: 52.644419 |0|0|0| I 32 CAL0001: WriteEngine main process has started
Apr  6 12:31:52 ip-10-111-0-54 controllernode[5292]: 52.662442 |0|0|0| C 29 CAL0000: InetStreamSocket::readToMagic(): I/O error1: rc-1; poll signal interrupt ( POLLHUP POLLERR )
Apr  6 12:31:52 ip-10-111-0-54 IDBFile[5462]: 52.720080 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:52 ip-10-111-0-54 DMLProc[5462]: 52.743828 |0|0|0| I 20 CAL0002: DMLProc starts rollbackAll.
Apr  6 12:31:52 ip-10-111-0-54 DMLProc[5462]: 52.771371 |0|0|0| I 20 CAL0002: DMLProc will rollback 0 tables.
Apr  6 12:31:52 ip-10-111-0-54 DMLProc[5462]: 52.783905 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll.
Apr  6 12:31:52 ip-10-111-0-54 ddlpackageproc[5459]: 52.791405 |0|0|0| C 23 CAL0008: DMLProc main process has started
Apr  6 12:31:52 ip-10-111-0-54 controllernode[5292]: 52.809273 |0|0|0| C 29 CAL0000: InetStreamSocket::readToMagic(): I/O error1: rc-1; poll signal interrupt ( POLLHUP POLLERR )
Apr  6 12:31:52 ip-10-111-0-54 IDBFile[5493]: 52.863932 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:52 ip-10-111-0-54 ddlpackageproc[5491]: 52.897652 |0|0|0| C 23 CAL0008: DDLProc main process has started
Apr  6 12:31:52 ip-10-111-0-54 IDBFile[5502]: 52.970970 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:31:52 ip-10-111-0-54 writeengine[5502]: 52.997717 |0|0|0| I 19 CAL0060: dbbuilder system catalog status: System catalog appears to exist.  It will remain intact for reuse.  The database is not recreated.
Apr  6 12:39:52 ip-10-111-0-54 ExeMgr[5432]: 52.721758 |2147483852|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='app' and tablename='client20_company_settings' --columnRIDs/FE; ||
Apr  6 12:39:52 ip-10-111-0-54 ExeMgr[5432]: 52.796655 |2147483852|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:39:53 ip-10-111-0-54 ExeMgr[5432]: 53.030550 |204|0|0| D 16 CAL0041: Start SQL statement: SELECT COUNT(*) FROM client20_company_settings; |app|
Apr  6 12:39:53 ip-10-111-0-54 ExeMgr[5432]: 53.118270 |204|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:39:53 ip-10-111-0-54 ExeMgr[5432]: 53.819356 |2147483854|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='app' and tablename='client20_subcategory_settings' --columnRIDs/FE; ||
Apr  6 12:39:53 ip-10-111-0-54 ExeMgr[5432]: 53.885833 |2147483854|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:39:54 ip-10-111-0-54 ExeMgr[5432]: 54.117899 |206|0|0| D 16 CAL0041: Start SQL statement: SELECT COUNT(*) FROM client20_subcategory_settings; |app|
Apr  6 12:39:54 ip-10-111-0-54 ExeMgr[5432]: 54.163917 |206|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:40:43 ip-10-111-0-54 ddlpackageproc[5493]: 43.822089 |237|19733|0| D 23 CAL0041: Start SQL statement: CREATE TABLE app.client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe (#012#011year INTEGER, #012#011month INTEGER, #012#011payment_terms VARCHAR(5), #012#011vendor_id VARCHAR(10), #012#011women_owned VARCHAR(1), #012#011mega_division_number VARCHAR(20), #012#011ethnicity2 VARCHAR(1), #012#011invoice_number VARCHAR(30), #012#011normalized_vendor_name VARCHAR(50), #012#011original_amount DECIMAL(18, 2), #012#011gl_description VARCHAR(30), #012#011cost_center_number VARCHAR(10), #012#011division VARCHAR(30), #012#011super_division VARCHAR(30), #012#011simple_vendor_name VARCHAR(50), #012#011diversity_owned VARCHAR(3), #012#011spendanalysis_id INTEGER, #012#011parent_work_order_id VARCHAR(14), #012#011child_work_order_id VARCHAR(15), #012#011original_vendor_name VARCHAR(40), #012#011transferred INTEGER, #012#011city VARCHAR(13), #012#011data_source VARCHAR(6), #012#011po_number VARCHAR(25), #012#011ethnicity_language VARCHAR(29), #012#011id INTEGER, #012#011veteran_owned VARCHAR(1), #012#011state VARCHAR(2), #012#011disabled VARCHAR(1), #012#011amount DECIMAL(18, 2), #012#011mega_division VARCHAR(30), #012#011vendor_type VARCHAR(28), #012#011category VARCHAR(26), #012#011subcategory VARCHAR(39), #012#011date DATE, #012#011supplier_preferred VARCHAR(3), #012#011cost_center VARCHAR(30), #012#011voucher VARCHAR(8), #012#011base_currency VARCHAR(3), #012#011department VARCHAR(30), #012#011gl_code VARCHAR(6), #012#011original_currency VARCHAR(3), #012#011veteran_flag VARCHAR(1), #012#011is_preferred INTEGER, #012#011is_managed INTEGER, #012#011impactable INTEGER, #012#011include_in_savings INTEGER, #012#011lost_savings_rate INTEGER, #012#011compliance_status VARCHAR(13)#012)DEFAULT CHARSET=utf8mb4 ENGINE=Columnstore COLLATE utf8mb4_nopad_bin;|app|
Apr  6 12:40:44 ip-10-111-0-54 ddlpackageproc[5493]: 44.896104 |237|19733|0| D 23 CAL0042: End SQL statement
Apr  6 12:40:48 ip-10-111-0-54 writeengineserver[5453]: 48.392125 |0|0|0| D 32 CAL0000: 8864 : onReceiveMode() Setting fMode = 1
Apr  6 12:40:48 ip-10-111-0-54 writeengineserver[5453]: 48.392608 |0|0|0| D 32 CAL0000: 8864 : onReceiveMode() DbRoot Count = 1
Apr  6 12:40:48 ip-10-111-0-54 writeengineserver[5453]: 48.392681 |0|0|0| D 32 CAL0000: 8864 : CMD LINE ARGS came in /usr/bin/cpimport.bin -L /var/log/mariadb/columnstore/cpimport/ -E " -R /tmp/columnstore_tmp_files/BrmRpt03061240487830.rpt -m 1 -P pm1-7830 -T SYSTEM -uc0b5ed65-b239-498c-a82b-432da20ce104 app client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe
Apr  6 12:40:48 ip-10-111-0-54 writeengineserver[5453]: 48.392752 |0|0|0| D 32 CAL0000: 8864 : Brm Rpt Filename Arrived /tmp/columnstore_tmp_files/BrmRpt03061240487830.rpt
Apr  6 12:40:48 ip-10-111-0-54 writeengineserver[5453]: 48.392794 |0|0|0| D 32 CAL0000: 8864 : Start Cpimport command reached!!
Apr  6 12:40:48 ip-10-111-0-54 cpimport.bin[7858]: 48.427693 |0|0|0| I 34 CAL0086: Initiating BulkLoad: -L /var/log/mariadb/columnstore/cpimport/ -E " -R /tmp/columnstore_tmp_files/BrmRpt03061240487830.rpt -m 1 -P pm1-7830 -T SYSTEM -uc0b5ed65-b239-498c-a82b-432da20ce104 app client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe
Apr  6 12:40:48 ip-10-111-0-54 IDBFile[7858]: 48.430059 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Apr  6 12:40:48 ip-10-111-0-54 cpimport.bin[7858]: 48.590592 |0|0|0| I 34 CAL0081: Start BulkLoad: JobId-280864; db-app
Apr  6 12:40:52 ip-10-111-0-54 writeenginesplit[7830]: 52.878294 |0|0|0| I 33 CAL0000: Send EOD message to All PMs
Apr  6 12:40:52 ip-10-111-0-54 writeengineserver[5453]: 52.893315 |0|0|0| D 32 CAL0000: 8864 : onReceiveEOD : child ID = 7858
Apr  6 12:40:52 ip-10-111-0-54 writeengineserver[5453]: 52.894106 |0|0|0| D 32 CAL0000: 8864 : Message Queue is empty; Stopping CF Thread
Apr  6 12:40:53 ip-10-111-0-54 writeenginesplit[7830]: 53.527850 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2.
Apr  6 12:40:53 ip-10-111-0-54 cpimport.bin[7858]: 53.564953 |0|0|0| I 34 CAL0083: BulkLoad: JobId-280864; finished loading table app.client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe; 290000 rows inserted
Apr  6 12:40:53 ip-10-111-0-54 writeengine[7858]: 53.565005 |0|0|0| I 19 CAL0008: Bulkload |Job: /var/log/mariadb/columnstore/data/bulk/tmpjob/280864_D20220406_T124048_S494808_Job_280864.xml |For table app.client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe: 290000 rows processed and 290000 rows inserted.
Apr  6 12:40:53 ip-10-111-0-54 cpimport.bin[7858]: 53.578248 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-280864; status-SUCCESS
Apr  6 12:40:53 ip-10-111-0-54 writeengineserver[5453]: 53.587422 |0|0|0| I 32 CAL0000: 8864 : cpimport exit on success
Apr  6 12:40:53 ip-10-111-0-54 writeengineserver[5453]: 53.587620 |0|0|0| D 32 CAL0000: 8864 : onCpimportSuccess BrmReport Send
Apr  6 12:40:53 ip-10-111-0-54 writeengineserver[5453]: 53.587663 |0|0|0| D 32 CAL0000: 8864 : onReceiveEOD : child ID = 0
Apr  6 12:40:53 ip-10-111-0-54 writeengineserver[5453]: 53.587699 |0|0|0| D 32 CAL0000: 8864 : onReceiveEOD : child ID = 0
Apr  6 12:40:53 ip-10-111-0-54 writeenginesplit[7830]: 53.589821 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1.
Apr  6 12:40:55 ip-10-111-0-54 writeenginesplit[7830]: 55.648967 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3.
Apr  6 12:40:55 ip-10-111-0-54 writeengineserver[5453]: 55.648954 |0|0|0| D 32 CAL0000: 8864 : OnReceiveCleanup arrived
Apr  6 12:40:55 ip-10-111-0-54 writeenginesplit[7830]: 55.662756 |0|0|0| I 33 CAL0000: Released Table Lock
Apr  6 12:40:56 ip-10-111-0-54 ExeMgr[5432]: 56.635605 |2147483912|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='app' and tablename='client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe' --columnRIDs/FE; ||
Apr  6 12:40:56 ip-10-111-0-54 ExeMgr[5432]: 56.703774 |2147483912|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:40:56 ip-10-111-0-54 ExeMgr[5432]: 56.940916 |264|0|0| D 16 CAL0041: Start SQL statement: SELECT COUNT(*) FROM client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe; |app|
Apr  6 12:40:56 ip-10-111-0-54 ExeMgr[5432]: 56.968658 |264|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:40:57 ip-10-111-0-54 ddlpackageproc[5493]: 57.023880 |265|19734|0| D 23 CAL0041: Start SQL statement: DROP TABLE `app`.`client20spenddata_backup`;|app|
Apr  6 12:40:57 ip-10-111-0-54 ddlpackageproc[5493]: 57.609414 |265|19734|0| D 23 CAL0042: End SQL statement
Apr  6 12:40:57 ip-10-111-0-54 ddlpackageproc[5493]: 57.692528 |269|19735|0| D 23 CAL0041: Start SQL statement: alter table `app`.`client20spenddata` rename to `app`.`client20spenddata_backup`;|app|
Apr  6 12:40:57 ip-10-111-0-54 ddlpackageproc[5493]: 57.866524 |269|19735|0| D 23 CAL0042: End SQL statement
Apr  6 12:40:57 ip-10-111-0-54 ddlpackageproc[5493]: 57.899882 |269|19736|0| D 23 CAL0041: Start SQL statement: alter table `app`.`client20spenddata_stg_0f11644e_f1bb_4af5_adfd_529fe1cdb5fe` rename to `app`.`client20spenddata`;|app|
Apr  6 12:40:58 ip-10-111-0-54 ddlpackageproc[5493]: 58.078892 |269|19736|0| D 23 CAL0042: End SQL statement
Apr  6 12:41:28 ip-10-111-0-54 ExeMgr[5432]: 28.280211 |2147483996|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='app' and tablename='client451spenddata' --columnRIDs/FE; ||
Apr  6 12:41:28 ip-10-111-0-54 ExeMgr[5432]: 28.347154 |2147483996|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:41:28 ip-10-111-0-54 ExeMgr[5432]: 28.591079 |348|0|0| D 16 CAL0041: Start SQL statement: WITH OLD as (select normalized_vendor_name AS `old_supplier` from `client451spenddata` where `date` < '2021-12-01' and (`data_source` is null or `data_source` not in ('Oracle')) and (`category` is null or `category` not in ('UNADDRESSABLE')) group by `old_supplier`),#012NEW_SUPPLIERS as (select normalized_vendor_name AS `new_supplier`, SUM(amount) AS `supplier_spend` from `client451spenddata` left join `OLD` on `normalized_vendor_name` = `OLD`.`old_supplier` where `date` between '2021-12-01 00:00:00' and '2022-02-28 00:00:00' and `OLD`.`old_supplier` is null and (`data_source` is null or `data_source` not in ('Oracle')) and (`category` is null or `category` not in ('UNADDRESSABLE')) group by `normalized_vendor_name` having supplier_spend >= 250000),#012CURRENT as (select normalized_vendor_name, SUM(amount) AS `amount` from `client451spenddata` left join `NEW_SUPPLIERS` on `NEW_SUPPLIERS`.`new_supplier` = `normalized_vendor_name` where `date` between '2021-12-01 00:00:00' and '2022-02-28 00:00:00' and `NEW_SUPPLIERS`.`new_supplier` is not null and (`data_source` is null or `data_source` not in ('Oracle')) and (`category` is null or `category` not in ('UNADDRESSABLE')) group by `normalized_vendor_name`) select sum(CURRENT.amount) AS total, count(distinct CURRENT.normalized_vendor_name) AS count from `CURRENT`; |app|
Apr  6 12:41:28 ip-10-111-0-54 ExeMgr[5432]: 28.793514 |348|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:41:28 ip-10-111-0-54 ExeMgr[5432]: 28.992846 |2147483998|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='app' and tablename='client451spenddata' --columnRIDs/FE; ||
Apr  6 12:41:29 ip-10-111-0-54 ExeMgr[5432]: 29.059890 |2147483998|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:41:29 ip-10-111-0-54 ExeMgr[5432]: 29.299765 |350|0|0| D 16 CAL0041: Start SQL statement: WITH OLD as (select normalized_vendor_name AS `old_supplier` from `client451spenddata` where `date` < '2021-12-01' and (`data_source` is null or `data_source` not in ('Oracle')) and (`category` is null or `category` not in ('UNADDRESSABLE')) group by `old_supplier`),#012NEW_SUPPLIERS as (select normalized_vendor_name AS `new_supplier`, SUM(amount) AS `supplier_spend` from `client451spenddata` left join `OLD` on `normalized_vendor_name` = `OLD`.`old_supplier` where `date` between '2021-12-01 00:00:00' and '2022-02-28 00:00:00' and `OLD`.`old_supplier` is null and (`data_source` is null or `data_source` not in ('Oracle')) and (`category` is null or `category` not in ('UNADDRESSABLE')) group by `normalized_vendor_name` having supplier_spend >= 250000),#012CURRENT as (select SUM(amount) AS `amount`, normalized_vendor_name AS `normalized_vendor_name`, if(SUM(is_preferred) > 0, true, false) AS `is_preferred`, IF(SUM(is_diverse) > 0, true, false) AS `is_diverse` from `client451spenddata` where `date` between '2021-12-01 00:00:00' and '2022-02-28 00:00:00' and (`category` is null or `category` not in ('UNADDRESSABLE')) group by `normalized_vendor_name`) select CURRENT.normalized_vendor_name AS `supplier`, CURRENT.amount AS `supplier_spend`, CURRENT.is_preferred, CURRENT.is_diverse, NEW_SUPPLIERS.new_supplier IS NOT NULL AS `is_new`, COUNT(CURRENT.normalized_vendor_name) over (rows BETWEEN unbounded preceding AND unbounded following) AS `total` from `CURRENT` left join `NEW_SUPPLIERS` on `NEW_SUPPLIERS`.`new_supplier` = `CURRENT`.`normalized_vendor_name` order by `supplier_spend` desc; |app|
Apr  6 12:41:29 ip-10-111-0-54 ExeMgr[5432]: 29.482171 |350|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:41:29 ip-10-111-0-54 ExeMgr[5432]: 29.977420 |2147484008|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='app' and tablename='client174spenddata' --columnRIDs/FE; ||
Apr  6 12:41:30 ip-10-111-0-54 ExeMgr[5432]: 30.045525 |2147484008|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:41:30 ip-10-111-0-54 ExeMgr[5432]: 30.300560 |360|0|0| D 16 CAL0041: Start SQL statement: WITH OLD as (select normalized_vendor_name AS `old_supplier` from `client174spenddata` where `date` < '2021-01-01' and `subcategory` = 'Fleet Vehicle Rental' group by `old_supplier`),#012NEW_SUPPLIERS as (select normalized_vendor_name AS `new_supplier`, SUM(amount) AS `supplier_spend` from `client174spenddata` left join `OLD` on `normalized_vendor_name` = `OLD`.`old_supplier` where `date` between '2021-01-01 00:00:00' and '2021-12-31 00:00:00' and `OLD`.`old_supplier` is null and `subcategory` = 'Fleet Vehicle Rental' group by `normalized_vendor_name` having supplier_spend >= '0'),#012CURRENT as (select SUM(amount) AS `amount`, normalized_vendor_name AS `normalized_vendor_name`, if(SUM(is_preferred) > 0, true, false) AS `is_preferred`, false AS `is_diverse` from `client174spenddata` where `date` between '2021-01-01 00:00:00' and '2021-12-31 00:00:00' and `subcategory` = 'Fleet Vehicle Rental' group by `normalized_vendor_name`) select CURRENT.normalized_vendor_name AS `normalized_vendor_name`, CURRENT.amount AS `amount`, CURRENT.is_preferred, CURRENT.is_diverse, NEW_SUPPLIERS.new_supplier IS NOT NULL AS `is_new` from `CURRENT` left join `NEW_SUPPLIERS` on `NEW_SUPPLIERS`.`new_supplier` = `CURRENT`.`normalized_vendor_name` order by `amount` desc; |app|
Apr  6 12:41:30 ip-10-111-0-54 ExeMgr[5432]: 30.614748 |360|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:42:26 ip-10-111-0-54 ExeMgr[5432]: 26.743068 |2147484100|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='app' and tablename='client33spenddata' --columnRIDs/FE; ||
Apr  6 12:42:26 ip-10-111-0-54 ExeMgr[5432]: 26.807333 |2147484100|0|0| D 16 CAL0042: End SQL statement
Apr  6 12:42:27 ip-10-111-0-54 ExeMgr[5432]: 27.048193 |452|0|0| D 16 CAL0041: Start SQL statement: WITH OLD as (select normalized_vendor_name AS `old_supplier` from `client33spenddata` where `date` < '2021-01-01' and `subcategory` = 'Internal Transfer' group by `old_supplier`),#012NEW_SUPPLIERS as (select normalized_vendor_name AS `new_supplier`, SUM(amount) AS `supplier_spend` from `client33spenddata` left join `OLD` on `normalized_vendor_name` = `OLD`.`old_supplier` where `date` between '2021-01-01 00:00:00' and '2021-12-31 00:00:00' and `OLD`.`old_supplier` is null and `subcategory` = 'Internal Transfer' group by `normalized_vendor_name` having supplier_spend >= '0'),#012CURRENT as (select SUM(amount) AS `amount`, normalized_vendor_name AS `normalized_vendor_name`, if(SUM(is_preferred) > 0, true, false) AS `is_preferred`, IF(SUM(is_diverse) > 0, true, false) AS `is_diverse` from `client33spenddata` where `date` between '2021-01-01 00:00:00' and '2021-12-31 00:00:00' and `subcategory` = 'Internal Transfer' group by `normalized_vendor_name`) select CURRENT.normalized_vendor_name AS `normalized_vendor_name`, CURRENT.amount AS `amount`, CURRENT.is_preferred, CURRENT.is_diverse, NEW_SUPPLIERS.new_supplier IS NOT NULL AS `is_new` from `CURRENT` left join `NEW_SUPPLIERS` on `NEW_SUPPLIERS`.`new_supplier` = `CURRENT`.`normalized_vendor_name` order by `amount` desc; |app|