[madamec@Martins-MacBook-Pro-2 ~]$ ssh cs121um1_1 ############################################################################### #-----------------------------------------------------------------------------# # Authorized access only! # # Disconnect IMMEDIATELY if you are not an authorized user!!! # # All actions will be monitored and recorded. # #-----------------------------------------------------------------------------# ############################################################################### Last login: Fri Dec 7 23:40:08 2018 from ip-172-31-16-18.ec2.internal [madamec@cstore-um1-1 ~]$ mcsmysql -uroot Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 27 Server version: 10.3.11-MariaDB-log Columnstore 1.2.2-1 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use dds_zmnlu2chkwifdugygq9v Database changed MariaDB [dds_zmnlu2chkwifdugygq9v]> show variables like "%vtable%"; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | infinidb_vtable_mode | 1 | +----------------------+-------+ 1 row in set (0.001 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> SELECT bev.`daycounter`, bev.`actual_spot`, bev.`imputed_price`, bev.`imputed_rf_rate`, bev.`market_date`, bev.`implied_vol`, bev.`anl_delta`, bev.`anl_gamma`, bev.`vega`, bev.`rho`, bev.`theta`, bev.`imputed_div_yield`, bev.`dyg`, bev.`hedge_position`, bev.`hedge_price`, bev.`basis` FROM `book_entry_daily_values` AS bev JOIN load_batch AS lb ON bev.`batch_id` = lb.`id` AND (lb.`status` = 'SUCCESS' OR lb.`status` = 'STARTED') WHERE ((bev.`market_date` = '2018-03-06' AND bev.`daycounter` > 0) OR (bev.`market_date` = '2018-03-07' AND bev.`daycounter` = 0)) AND bev.`book_entry_id` = 5639; Empty set (0.248 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> set infinidb_vtable_mode = 0; Query OK, 0 rows affected (0.000 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> SELECT bev.`daycounter`, bev.`actual_spot`, bev.`imputed_price`, bev.`imputed_rf_rate`, bev.`market_date`, bev.`implied_vol`, bev.`anl_delta`, bev.`anl_gamma`, bev.`vega`, bev.`rho`, bev.`theta`, bev.`imputed_div_yield`, bev.`dyg`, bev.`hedge_position`, bev.`hedge_price`, bev.`basis` FROM `book_entry_daily_values` AS bev JOIN load_batch AS lb ON bev.`batch_id` = lb.`id` AND (lb.`status` = 'SUCCESS' OR lb.`status` = 'STARTED') WHERE ((bev.`market_date` = '2018-03-06' AND bev.`daycounter` > 0) OR (bev.`market_date` = '2018-03-07' AND bev.`daycounter` = 0)) AND bev.`book_entry_id` = 5639; +------------+-------------+---------------+-----------------+-------------+-------------+--------------+--------------+------------+------------+-------------+-------------------+------+----------------+-------------+--------+ | daycounter | actual_spot | imputed_price | imputed_rf_rate | market_date | implied_vol | anl_delta | anl_gamma | vega | rho | theta | imputed_div_yield | dyg | hedge_position | hedge_price | basis | +------------+-------------+---------------+-----------------+-------------+-------------+--------------+--------------+------------+------------+-------------+-------------------+------+----------------+-------------+--------+ | 0 | 89.5200 | 0.0000 | 0.020061 | 2018-03-07 | 0.0100000 | 0.9913461232 | 0.0000000000 | -0.0000039 | 55.9085276 | -0.00369077 | NULL | NULL | 0 | 89.5200 | 0.0000 | +------------+-------------+---------------+-----------------+-------------+-------------+--------------+--------------+------------+------------+-------------+-------------------+------+----------------+-------------+--------+ 1 row in set (0.109 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> set infinidb_vtable_mode = 1; Query OK, 0 rows affected (0.000 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> SELECT bev.`daycounter`, bev.`actual_spot`, bev.`imputed_price`, bev.`imputed_rf_rate`, bev.`market_date`, bev.`implied_vol`, bev.`anl_delta`, bev.`anl_gamma`, bev.`vega`, bev.`rho`, bev.`theta`, bev.`imputed_div_yield`, bev.`dyg`, bev.`hedge_position`, bev.`hedge_price`, bev.`basis` FROM `book_entry_daily_values` AS bev JOIN load_batch AS lb ON bev.`batch_id` = lb.`id` AND (lb.`status` = 'SUCCESS' OR lb.`status` = 'STARTED') WHERE ((bev.`market_date` = '2018-03-06' AND bev.`daycounter` > 0) OR (bev.`market_date` = '2018-03-07' AND bev.`daycounter` = 0)) AND bev.`book_entry_id` = 5639; Empty set (0.042 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> select calSetTrace(1); +----------------+ | calSetTrace(1) | +----------------+ | 0 | +----------------+ 1 row in set (0.001 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> SELECT bev.`daycounter`, bev.`actual_spot`, bev.`imputed_price`, bev.`imputed_rf_rate`, bev.`market_date`, bev.`implied_vol`, bev.`anl_delta`, bev.`anl_gamma`, bev.`vega`, bev.`rho`, bev.`theta`, bev.`imputed_div_yield`, bev.`dyg`, bev.`hedge_position`, bev.`hedge_price`, bev.`basis` FROM `book_entry_daily_values` AS bev JOIN load_batch AS lb ON bev.`batch_id` = lb.`id` AND (lb.`status` = 'SUCCESS' OR lb.`status` = 'STARTED') WHERE ((bev.`market_date` = '2018-03-06' AND bev.`daycounter` > 0) OR (bev.`market_date` = '2018-03-07' AND bev.`daycounter` = 0)) AND bev.`book_entry_id` = 5639; Empty set, 1 warning (0.046 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> select calGetTrace(); +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | calGetTrace() | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows CES UM - - - - - - 0.000 251 BPS PM bev 3247 (actual_spot,anl_delta,anl_gamma,basis,batch_id,book_entry_id,daycounter,dyg,hedge_position,hedge_price,implied_vol,imputed_div_yield,imputed_price,imputed_rf_rate,market_date,rho,theta,vega) 0 962 5 0.006 0 HJS PM bev-lb 3247 - - - - ----- - TNS UM - - - - - - 0.000 0 | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> set infinidb_vtable_mode = 0; Query OK, 0 rows affected (0.000 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> select calGetTrace(1); +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | calGetTrace(1) | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | CES: ses:27 st: 0 finished at Sun Dec 9 13:19:13 2018; rows retrieved-251; total rows returned-251 1st read 2018-12-09 13:19:13.520568; EOI 2018-12-09 13:19:13.520799; runtime-0.000231s; UUID ee923a20-5839-4383-ba56-b72417bce304 Job completion status 0 TBPS: TupleBPS ses:27 txn:0 ver: SCN: 362 Txns: st:1 tb/col:3247/3308 alias:bev not del (0x7f2ce064e550[19]) nf:0 in: UUID: 7f72c6bb-d489-41c9-8003-806b7fe7feb3 Query UUID: 887cd470-c170-48ab-a20c-1b72f6ec778b BatchPrimitiveProcessorJL: -- scan driven 2 filter steps: ColumnCommandJL: 0 filters colwidth=4 oid=3308 name=batch_id (scan) ColumnCommandJL: 1 filters colwidth=4 oid=3249 name=book_entry_id 17 projection steps: ColumnCommandJL: 0 filters colwidth=4 oid=3308 name=batch_id ColumnCommandJL: 0 filters colwidth=4 oid=3252 name=daycounter ColumnCommandJL: 0 filters colwidth=8 oid=3255 name=actual_spot ColumnCommandJL: 0 filters colwidth=8 oid=3254 name=imputed_price ColumnCommandJL: 0 filters colwidth=4 oid=3260 name=imputed_rf_rate ColumnCommandJL: 0 filters colwidth=4 oid=3250 name=market_date ColumnCommandJL: 0 filters colwidth=8 oid=3258 name=implied_vol ColumnCommandJL: 0 filters colwidth=8 oid=3262 name=anl_delta ColumnCommandJL: 0 filters colwidth=8 oid=3264 name=anl_gamma ColumnCommandJL: 0 filters colwidth=8 oid=3265 name=vega ColumnCommandJL: 0 filters colwidth=8 oid=3267 name=rho ColumnCommandJL: 0 filters colwidth=8 oid=3269 name=theta ColumnCommandJL: 0 filters colwidth=4 oid=3259 name=imputed_div_yield ColumnCommandJL: 0 filters colwidth=8 oid=3271 name=dyg ColumnCommandJL: 0 filters colwidth=4 oid=3305 name=hedge_position ColumnCommandJL: 0 filters colwidth=8 oid=3295 name=hedge_price ColumnCommandJL: 0 filters colwidth=8 oid=3297 name=basis ses:27 st: 1 finished at 2018-12-09 13:19:13.528059; PhyI/O-0; CacheI/O-962; MsgsSent-215; MsgsRvcd-215; BlocksTouched-962; BlockedFifoIn/Out-0/0; output size-0 PartitionBlocksEliminated-5; MsgBytesIn-23KB; MsgBytesOut-25KB; TotalMsgs-215 1st read 2018-12-09 13:19:13.521469; EOI 2018-12-09 13:19:13.528032; runtime-0.006563s UUID 7f72c6bb-d489-41c9-8003-806b7fe7feb3 Query UUID 887cd470-c170-48ab-a20c-1b72f6ec778b Job completion status 0 THJS: TupleHashJoinStep ses:27 st:2 in tb/col:0/1 (0x7f2ce06bd2a0[19]) in *tb/col:0/0 (0x7f2ce06e21c0[19]) out tb/col:0/100 (0x7f2ce064e550[19]) PM join (0) TNS: ses:27 st: 3 finished at Sun Dec 9 13:19:13 2018; total rows returned-0 1st read 2018-12-09 13:19:13.528365; EOI 2018-12-09 13:19:13.528386; runtime-0.000021s; UUID 4771c72a-080c-4775-ae3a-aebab83627db Job completion status 0 | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> select calGetTrace(); +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | calGetTrace() | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows CES UM - - - - - - 0.000 251 BPS PM bev 3247 (actual_spot,anl_delta,anl_gamma,basis,batch_id,book_entry_id,daycounter,dyg,hedge_position,hedge_price,implied_vol,imputed_div_yield,imputed_price,imputed_rf_rate,market_date,rho,theta,vega) 0 962 5 0.006 0 HJS PM bev-lb 3247 - - - - ----- - TNS UM - - - - - - 0.000 0 | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> SELECT bev.`daycounter`, bev.`actual_spot`, bev.`imputed_price`, bev.`imputed_rf_rate`, bev.`market_date`, bev.`implied_vol`, bev.`anl_delta`, bev.`anl_gamma`, bev.`vega`, bev.`rho`, bev.`theta`, bev.`imputed_div_yield`, bev.`dyg`, bev.`hedge_position`, bev.`hedge_price`, bev.`basis` FROM `book_entry_daily_values` AS bev JOIN load_batch AS lb ON bev.`batch_id` = lb.`id` AND (lb.`status` = 'SUCCESS' OR lb.`status` = 'STARTED') WHERE ((bev.`market_date` = '2018-03-06' AND bev.`daycounter` > 0) OR (bev.`market_date` = '2018-03-07' AND bev.`daycounter` = 0)) AND bev.`book_entry_id` = 5639; +------------+-------------+---------------+-----------------+-------------+-------------+--------------+--------------+------------+------------+-------------+-------------------+------+----------------+-------------+--------+ | daycounter | actual_spot | imputed_price | imputed_rf_rate | market_date | implied_vol | anl_delta | anl_gamma | vega | rho | theta | imputed_div_yield | dyg | hedge_position | hedge_price | basis | +------------+-------------+---------------+-----------------+-------------+-------------+--------------+--------------+------------+------------+-------------+-------------------+------+----------------+-------------+--------+ | 0 | 89.5200 | 0.0000 | 0.020061 | 2018-03-07 | 0.0100000 | 0.9913461232 | 0.0000000000 | -0.0000039 | 55.9085276 | -0.00369077 | NULL | NULL | 0 | 89.5200 | 0.0000 | +------------+-------------+---------------+-----------------+-------------+-------------+--------------+--------------+------------+------------+-------------+-------------------+------+----------------+-------------+--------+ 1 row in set, 1 warning (0.040 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> select calGetTrace(); +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | calGetTrace() | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows BPS PM bev 3247 (actual_spot,anl_delta,anl_gamma,basis,batch_id,book_entry_id,daycounter,dyg,hedge_position,hedge_price,implied_vol,imputed_div_yield,imputed_price,imputed_rf_rate,market_date,rho,theta,vega) 0 877 5 0.006 1 TNS UM - - - - - - 0.004 1 | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]> select calGetTrace(1); +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | calGetTrace(1) | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | TBPS: TupleBPS ses:27 txn:0 ver: SCN: 362 Txns: st:0 tb/col:3247/3249 alias:bev not del (0x7f2ca00bb7f0[19]) nf:1 in: UUID: 54a3999f-86ad-45ef-8662-33c433aa7233 Query UUID: 9197650a-2b89-4f76-8653-2f13481ba8ca BatchPrimitiveProcessorJL: -- scan driven 1 filter steps: ColumnCommandJL: 1 filters colwidth=4 oid=3249 name=book_entry_id (scan) 18 projection steps: ColumnCommandJL: 0 filters colwidth=4 oid=3249 name=book_entry_id ColumnCommandJL: 0 filters colwidth=4 oid=3250 name=market_date ColumnCommandJL: 0 filters colwidth=4 oid=3252 name=daycounter ColumnCommandJL: 0 filters colwidth=8 oid=3254 name=imputed_price ColumnCommandJL: 0 filters colwidth=8 oid=3255 name=actual_spot ColumnCommandJL: 0 filters colwidth=8 oid=3258 name=implied_vol ColumnCommandJL: 0 filters colwidth=4 oid=3259 name=imputed_div_yield ColumnCommandJL: 0 filters colwidth=4 oid=3260 name=imputed_rf_rate ColumnCommandJL: 0 filters colwidth=8 oid=3262 name=anl_delta ColumnCommandJL: 0 filters colwidth=8 oid=3264 name=anl_gamma ColumnCommandJL: 0 filters colwidth=8 oid=3265 name=vega ColumnCommandJL: 0 filters colwidth=8 oid=3267 name=rho ColumnCommandJL: 0 filters colwidth=8 oid=3269 name=theta ColumnCommandJL: 0 filters colwidth=8 oid=3271 name=dyg ColumnCommandJL: 0 filters colwidth=8 oid=3295 name=hedge_price ColumnCommandJL: 0 filters colwidth=8 oid=3297 name=basis ColumnCommandJL: 0 filters colwidth=4 oid=3305 name=hedge_position ColumnCommandJL: 0 filters colwidth=4 oid=3308 name=batch_id ses:27 st: 0 finished at 2018-12-09 13:22:21.940871; PhyI/O-0; CacheI/O-877; MsgsSent-215; MsgsRvcd-215; BlocksTouched-877; BlockedFifoIn/Out-0/0; output size-1 PartitionBlocksEliminated-5; MsgBytesIn-23KB; MsgBytesOut-16KB; TotalMsgs-215 1st read 2018-12-09 13:22:21.934332; EOI 2018-12-09 13:22:21.940845; runtime-0.006513s UUID 54a3999f-86ad-45ef-8662-33c433aa7233 Query UUID 9197650a-2b89-4f76-8653-2f13481ba8ca Job completion status 0 TNS: ses:27 st: 1 finished at Sun Dec 9 13:22:21 2018; total rows returned-1 1st read 2018-12-09 13:22:21.936479; EOI 2018-12-09 13:22:21.941201; runtime-0.004722s; UUID 6a95e74b-9570-4789-b485-af7449c5a2a9 Job completion status 0 | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [dds_zmnlu2chkwifdugygq9v]>