vtstran

2020-08-05 19:24:57:INFO:util:--------------------------------------
2020-08-05 19:24:57:INFO:util:- executing: setup_pre_first_run_cdh -
2020-08-05 19:24:57:INFO:util:--------------------------------------
2020-08-05 19:24:57:INFO:sysadmin:Staging parcels/packages
2020-08-05 19:25:57:INFO:cm_cluster:[Cluster 1] Deploying CDH-7.2.1-1.cdh7.2.1.p0.4847773
2020-08-05 19:25:57:INFO:cm_cluster:[Cluster 1] Downloading CDH-7.2.1-1.cdh7.2.1.p0.4847773
2020-08-05 19:27:33:INFO:cm_cluster:[Cluster 1] Distributing CDH-7.2.1-1.cdh7.2.1.p0.4847773
2020-08-05 19:31:19:INFO:cm_cluster:[Cluster 1] Activating CDH-7.2.1-1.cdh7.2.1.p0.4847773
2020-08-05 19:31:50:INFO:sysadmin:>>>> Completed staging parcels/packages. Took 412 seconds

vtstran

[durian-2:21000] > select c2=cast('09:09:09' as timestamp) from tt;
Query: select c2=cast('09:09:09' as timestamp) from tt
Query submitted at: 2017-06-18 05:59:15 (Coordinator: http://durian-2.gce.cloudera.com:25000)
Query progress can be monitored at: http://durian-2.gce.cloudera.com:25000/query_plan?query_id=a54127dccdde41d2:39a89e6d00000000
+------------------------------------+
| c2 = cast('09:09:09' as timestamp) |
+------------------------------------+
| true                               |
+------------------------------------+
[durian-2:21000] > select * from tt where c2 between cast('00:00:00' as timestamp) and cast('23:59:59' as timestamp);

vtstran

[kiwi-3:21000] > set explain_level=3;
EXPLAIN_LEVEL set to 3
[kiwi-3:21000] > explain select * from customers where id in ( 1,2,3 );
Query: explain select * from customers where id in ( 1,2,3 )
+-------------------------------------------------------+
| Explain String                                        |
+-------------------------------------------------------+
| Per-Host Resource Reservation: Memory=0B              |
| Per-Host Resource Estimates: Memory=16.00MB           |
|                                                       |

vtstran

Thread 1585 (crashed)
 0  0x0
    rax = 0x0000000000000000   rdx = 0x0000000000000001
    rcx = 0x00007ff360256658   rbx = 0x00007ff12c9c9c08
    rsi = 0x0000000000000000   rdi = 0x00007ff6acd89340
    rbp = 0x00007ff6acd89340   rsp = 0x00007ff2e57eaf88
     r8 = 0x000000000005f130    r9 = 0x00000000034b6000
    r10 = 0x0000000000000000   r11 = 0x0000000000000206
    r12 = 0x00007ff12c9c9f10   r13 = 0x0000000000c63920
    r14 = 0x00007ff6acd89080   r15 = 0x00007ff2e57ebb00

vtstran

Thread 293 (crashed)
 0  libc-2.12.so + 0x325e5
    rax = 0x0000000000000000   rdx = 0x0000000000000006
    rcx = 0xffffffffffffffff   rbx = 0x000000002cc4c118
    rsi = 0x0000000000004550   rdi = 0x0000000000003dd3
    rbp = 0x0000000002acd5c0   rsp = 0x00007f26764182c8
     r8 = 0x000000000000000a    r9 = 0x00007f267641a700
    r10 = 0x0000000000000008   r11 = 0x0000000000000202
    r12 = 0x00000000124e9100   r13 = 0x0000000002a70ea0
    r14 = 0x00000000215a1978   r15 = 0x00007f2676418890

vtstran

[localhost:21000] > select nvl2(int_col, 'not null', 'null'), int_col from alltypesagg limit 10;
Query: select nvl2(int_col, 'not null', 'null'), int_col from alltypesagg limit 10
Query submitted at: 2017-05-23 22:49:43 (Coordinator: http://loki:25000)
Query progress can be monitored at: http://loki:25000/query_plan?query_id=b741f8dd27ef7f60:2bc0a5c600000000
+---------------------------------------------+---------+
| if(int_col is not null, 'not null', 'null') | int_col |
+---------------------------------------------+---------+
| null                                        | NULL    |
| not null                                    | 1       |
| not null                                    | 2       |