impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mostafa Mokhtar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IMPALA-5296) Codegen for aggregation against 1K column table takes 5 minutes
Date Tue, 09 May 2017 20:17:04 GMT
Mostafa Mokhtar created IMPALA-5296:
---------------------------------------

             Summary: Codegen for aggregation against 1K column table takes 5 minutes
                 Key: IMPALA-5296
                 URL: https://issues.apache.org/jira/browse/IMPALA-5296
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 2.7.0
            Reporter: Mostafa Mokhtar
            Assignee: Tim Armstrong
         Attachments: codegen-widetable-profile.txt, wide_parquet_1000_small_data.0.parq


Parquet file for sample data attached. 

>From the query profile
{code}
    CodeGen:(Total: 3m6s, non-child: 3m6s, % non-child: 100.00%)
         - CodegenTime: 73.408ms
         - CompileTime: 48s511ms
         - LoadTime: 0.000ns
         - ModuleBitcodeSize: 1.98 MB (2074600)
         - NumFunctions: 2.07K (2066)
         - NumInstructions: 104.95K (104948)
         - OptimizationTime: 2m17s
         - PeakMemoryUsage: 51.24 MB (53733376)
         - PrepareTime: 18.414ms
      AGGREGATION_NODE (id=2):(Total: 3s413ms, non-child: 408.959us, % non-child: 0.01%)
         - BuildTime: 775.000ns
         - GetResultsTime: 0.000ns
         - HTResizeTime: 0.000ns
         - HashBuckets: 0 (0)
         - LargestPartitionPercent: 0 (0)
         - MaxPartitionLevel: 0 (0)
         - NumRepartitions: 0 (0)
         - PartitionsCreated: 0 (0)
         - PeakMemoryUsage: 16.00 KB (16384)
         - RowsRepartitioned: 0 (0)
         - RowsReturned: 1 (1)
         - RowsReturnedRate: 0
{code}

Query used to repro 
{code}
select count(*) from (select distinct * from wide_parquet_1000_small where l_orderkey = 10)
a
{code}

Hot functions from Perf 
{code}
Samples: 2M of event 'cycles', Event count (approx.): 1538632554190
+    6.09%     6.07%          impalad  impalad                        [.] llvm::ScalarEvolution::hasâ—†
+    5.75%     0.00%          impalad  [unknown]                      [.] 0000000000000000
 
+    5.46%     0.00%          impalad  [unknown]                      [.] 0x00007f8dfe242120
+    5.21%     0.00%          impalad  [unknown]                      [.] 0x00007f8e5e13ea20
+    4.31%     0.00%          impalad  [unknown]                      [.] 0x00007f8e5e13e8e8
+    4.31%     0.00%             init  [kernel.kallsyms]              [k] start_secondary
  
+    4.30%     0.02%             init  [kernel.kallsyms]              [k] cpu_idle       
  
+    4.03%     0.00%          impalad  [unknown]                      [.] 0x00007f8dfe241fe8
+    3.79%     3.77%          impalad  impalad                        [.] llvm::Use::getImpliedUser(
+    3.65%     0.02%             init  [kernel.kallsyms]              [k] cpuidle_idle_call

+    3.26%     2.78%          impalad  impalad                        [.] llvm::MemoryDependenceAnal
+    3.17%     3.15%          impalad  impalad                        [.] llvm::SmallPtrSetImplBase:
+    2.56%     2.52%          impalad  impalad                        [.] llvm::ScalarEvolution::get
+    2.51%     0.00%          impalad  [kernel.kallsyms]              [k] system_call_fastpath
     
+    2.20%     2.19%          impalad  impalad                        [.] llvm::SmallPtrSetImplBase:
+    2.17%     2.17%          impalad  impalad                        [.] llvm::MemoryDependenceAnal
+    2.06%     2.04%          impalad  impalad                        [.] llvm::AssumptionCache::sca
+    1.97%     0.38%          impalad  [kernel.kallsyms]              [k] page_fault     
  
+    1.95%     1.91%          impalad  impalad                        [.] llvm::BasicAAResult::alias
+    1.93%     1.88%          impalad  impalad                        [.] llvm::ScalarEvolution::For
+    1.91%     1.84%             init  [kernel.kallsyms]              [k] intel_idle     
  
+    1.78%     1.77%          impalad  impalad                        [.] llvm::Attribute::hasAttrib
+    1.72%     0.72%          impalad  impalad                        [.] operator delete[](void*,
s
+    1.71%     1.71%          impalad  impalad                        [.] llvm::BasicAAResult::alias
+    1.69%     1.02%          impalad  impalad                        [.] operator new[](unsigned
lo
+    1.67%     1.67%          impalad  impalad                        [.] LZ4_compress_fast_extState
+    1.60%     0.00%          impalad  [unknown]                      [.] 0x2000000000000001
+    1.59%     0.01%          impalad  [kernel.kallsyms]              [k] do_page_fault  
  
+    1.58%     0.03%          impalad  [kernel.kallsyms]              [k] __do_page_fault
  
+    1.58%     1.53%          impalad  impalad                        [.] llvm::ScalarEvolution::for
+    1.55%     0.00%          impalad  [unknown]                      [.] 0x0000000000000001
+    1.45%     0.05%          impalad  [kernel.kallsyms]              [k] handle_mm_fault
  
+    1.43%     1.35%          impalad  impalad                        [.] llvm::MemoryDependenceAnal
+    1.40%     0.04%          impalad  [kernel.kallsyms]              [k] handle_pte_fault
 
+    1.35%     0.37%          impalad  libc-2.12.so                   [.] __memset_sse2  
  
+    1.29%     0.00%             init  [kernel.kallsyms]              [k] irq_exit       
  
+    1.27%     1.26%          impalad  impalad                        [.] llvm::Value::stripPointerC
+    1.25%     1.25%          impalad  impalad                        [.] llvm::LiveVariables::addNe
+    1.23%     0.00%             init  [kernel.kallsyms]              [k] do_softirq     
  
+    1.23%     0.00%             init  [kernel.kallsyms]              [k] call_softirq   
  
+    1.22%     0.01%             init  [kernel.kallsyms]              [k] __do_softirq   
  
+    1.18%     1.18%          impalad  impalad                        [.] llvm::AttributeSet::getAtt
+    1.15%     0.59%          impalad  impalad                        [.] tcmalloc::ThreadCache::Rel
+    1.07%     0.00%          impalad  [unknown]                      [.] 0x00007f8d3814b960
+    1.07%     0.00%          impalad  [unknown]                      [.] 0x00007f8d3774a960
+    1.05%     1.05%          impalad  impalad                        [.] llvm::AttributeSetNode::ha
+    1.04%     0.00%          impalad  [unknown]                      [.] 0x00007f8dfe242138
{code}

DDL 
{code}
CREATE TABLE scan_primitives_tpch_3tb.wide_parquet_1000_small (
  l_orderkey BIGINT,
  l_partkey BIGINT, 
  l_suppkey BIGINT, 
  l_linenumber BIGINT,                                         
  l_quantity DOUBLE,
  l_extendedprice DOUBLE,                                      
  l_discount DOUBLE,
  l_tax DOUBLE,     
  l_returnflag STRING,                                         
  l_linestatus STRING,                                         
  l_commitdate STRING,                                         
  l_receiptdate STRING,                                        
  l_shipinstruct STRING,                                       
  l_shipmode STRING,
  l_comment STRING, 
  l_shipdate STRING,
  c1 STRING,        
  c2 STRING,        
  c3 STRING,        
  c4 STRING,        
  c5 STRING,        
  c6 STRING,        
  c7 STRING,        
  c8 STRING,        
  c9 STRING,        
  c10 STRING,       
  c11 STRING,       
  c12 STRING,       
  c13 STRING,       
  c14 STRING,       
  c15 STRING,       
  c16 STRING,       
  c17 STRING,       
  c18 STRING,       
  c19 STRING,       
  c20 STRING,       
  c21 STRING,       
  c22 STRING,       
  c23 STRING,       
  c24 STRING,       
  c25 STRING,       
  c26 STRING,       
  c27 STRING,       
  c28 STRING,       
  c29 STRING,       
  c30 STRING,       
  c31 STRING,       
  c32 STRING,       
  c33 STRING,       
  c34 STRING,       
  c35 STRING,       
  c36 STRING,       
  c37 STRING,       
  c38 STRING,       
  c39 STRING,       
  c40 STRING,       
  c41 STRING,       
  c42 STRING,       
  c43 STRING,       
  c44 STRING,       
  c45 STRING,       
  c46 STRING,       
  c47 STRING,       
  c48 STRING,       
  c49 STRING,       
  c50 STRING,       
  c51 STRING,       
  c52 STRING,       
  c53 STRING,       
  c54 STRING,       
  c55 STRING,       
  c56 STRING,       
  c57 STRING,       
  c58 STRING,       
  c59 STRING,       
  c60 STRING,       
  c61 STRING,       
  c62 STRING,       
  c63 STRING,       
  c64 STRING,       
  c65 STRING,       
  c66 STRING,       
  c67 STRING,       
  c68 STRING,       
  c69 STRING,       
  c70 STRING,       
  c71 STRING,       
  c72 STRING,       
  c73 STRING,       
  c74 STRING,       
  c75 STRING,       
  c76 STRING,       
  c77 STRING,       
  c78 STRING,       
  c79 STRING,       
  c80 STRING,       
  c81 STRING,       
  c82 STRING,       
  c83 STRING,       
  c84 STRING,       
  c85 STRING,       
  c86 STRING,       
  c87 STRING,       
  c88 STRING,       
  c89 STRING,       
  c90 STRING,       
  c91 STRING,       
  c92 STRING,       
  c93 STRING,       
  c94 STRING,       
  c95 STRING,       
  c96 STRING,       
  c97 STRING,       
  c98 STRING,       
  c99 STRING,       
  c100 STRING,      
  c101 STRING,      
  c102 STRING,      
  c103 STRING,      
  c104 STRING,      
  c105 STRING,      
  c106 STRING,      
  c107 STRING,      
  c108 STRING,      
  c109 STRING,      
  c110 STRING,      
  c111 STRING,      
  c112 STRING,      
  c113 STRING,      
  c114 STRING,      
  c115 STRING,      
  c116 STRING,      
  c117 STRING,      
  c118 STRING,      
  c119 STRING,      
  c120 STRING,      
  c121 STRING,      
  c122 STRING,      
  c123 STRING,      
  c124 STRING,      
  c125 STRING,      
  c126 STRING,      
  c127 STRING,      
  c128 STRING,      
  c129 STRING,      
  c130 STRING,      
  c131 STRING,      
  c132 STRING,      
  c133 STRING,      
  c134 STRING,      
  c135 STRING,      
  c136 STRING,      
  c137 STRING,      
  c138 STRING,      
  c139 STRING,      
  c140 STRING,      
  c141 STRING,      
  c142 STRING,      
  c143 STRING,      
  c144 STRING,      
  c145 STRING,      
  c146 STRING,      
  c147 STRING,      
  c148 STRING,      
  c149 STRING,      
  c150 STRING,      
  c151 STRING,      
  c152 STRING,      
  c153 STRING,      
  c154 STRING,      
  c155 STRING,      
  c156 STRING,      
  c157 STRING,      
  c158 STRING,      
  c159 STRING,      
  c160 STRING,      
  c161 STRING,      
  c162 STRING,      
  c163 STRING,      
  c164 STRING,      
  c165 STRING,      
  c166 STRING,      
  c167 STRING,      
  c168 STRING,      
  c169 STRING,      
  c170 STRING,      
  c171 STRING,      
  c172 STRING,      
  c173 STRING,      
  c174 STRING,      
  c175 STRING,      
  c176 STRING,      
  c177 STRING,      
  c178 STRING,      
  c179 STRING,      
  c180 STRING,      
  c181 STRING,      
  c182 STRING,      
  c183 STRING,      
  c184 STRING,      
  c185 STRING,      
  c186 STRING,      
  c187 STRING,      
  c188 STRING,      
  c189 STRING,      
  c190 STRING,      
  c191 STRING,      
  c192 STRING,      
  c193 STRING,      
  c194 STRING,      
  c195 STRING,      
  c196 STRING,      
  c197 STRING,      
  c198 STRING,      
  c199 STRING,      
  c200 STRING,      
  c201 STRING,      
  c202 STRING,      
  c203 STRING,      
  c204 STRING,      
  c205 STRING,      
  c206 STRING,      
  c207 STRING,      
  c208 STRING,      
  c209 STRING,      
  c210 STRING,      
  c211 STRING,      
  c212 STRING,      
  c213 STRING,      
  c214 STRING,      
  c215 STRING,      
  c216 STRING,      
  c217 STRING,      
  c218 STRING,      
  c219 STRING,      
  c220 STRING,      
  c221 STRING,      
  c222 STRING,      
  c223 STRING,      
  c224 STRING,      
  c225 STRING,      
  c226 STRING,      
  c227 STRING,      
  c228 STRING,      
  c229 STRING,      
  c230 STRING,      
  c231 STRING,      
  c232 STRING,      
  c233 STRING,      
  c234 STRING,      
  c235 STRING,      
  c236 STRING,      
  c237 STRING,      
  c238 STRING,      
  c239 STRING,      
  c240 STRING,      
  c241 STRING,      
  c242 STRING,      
  c243 STRING,      
  c244 STRING,      
  c245 STRING,      
  c246 STRING,      
  c247 STRING,      
  c248 STRING,      
  c249 STRING,      
  c250 STRING,      
  c251 STRING,      
  c252 STRING,      
  c253 STRING,      
  c254 STRING,      
  c255 STRING,      
  c256 STRING,      
  c257 STRING,      
  c258 STRING,      
  c259 STRING,      
  c260 STRING,      
  c261 STRING,      
  c262 STRING,      
  c263 STRING,      
  c264 STRING,      
  c265 STRING,      
  c266 STRING,      
  c267 STRING,      
  c268 STRING,      
  c269 STRING,      
  c270 STRING,      
  c271 STRING,      
  c272 STRING,      
  c273 STRING,      
  c274 STRING,      
  c275 STRING,      
  c276 STRING,      
  c277 STRING,      
  c278 STRING,      
  c279 STRING,      
  c280 STRING,      
  c281 STRING,      
  c282 STRING,      
  c283 STRING,      
  c284 STRING,      
  c285 STRING,      
  c286 STRING,      
  c287 STRING,      
  c288 STRING,      
  c289 STRING,      
  c290 STRING,      
  c291 STRING,      
  c292 STRING,      
  c293 STRING,      
  c294 STRING,      
  c295 STRING,      
  c296 STRING,      
  c297 STRING,      
  c298 STRING,      
  c299 STRING,      
  c300 STRING,      
  c301 STRING,      
  c302 STRING,      
  c303 STRING,      
  c304 STRING,      
  c305 STRING,      
  c306 STRING,      
  c307 STRING,      
  c308 STRING,      
  c309 STRING,      
  c310 STRING,      
  c311 STRING,      
  c312 STRING,      
  c313 STRING,      
  c314 STRING,      
  c315 STRING,      
  c316 STRING,      
  c317 STRING,      
  c318 STRING,      
  c319 STRING,      
  c320 STRING,      
  c321 STRING,      
  c322 STRING,      
  c323 STRING,      
  c324 STRING,      
  c325 STRING,      
  c326 STRING,      
  c327 STRING,      
  c328 STRING,      
  c329 STRING,      
  c330 STRING,      
  c331 STRING,      
  c332 STRING,      
  c333 STRING,      
  c334 STRING,      
  c335 STRING,      
  c336 STRING,      
  c337 STRING,      
  c338 STRING,      
  c339 STRING,      
  c340 STRING,      
  c341 STRING,      
  c342 STRING,      
  c343 STRING,      
  c344 STRING,      
  c345 STRING,      
  c346 STRING,      
  c347 STRING,      
  c348 STRING,      
  c349 STRING,      
  c350 STRING,      
  c351 STRING,      
  c352 STRING,      
  c353 STRING,      
  c354 STRING,      
  c355 STRING,      
  c356 STRING,      
  c357 STRING,      
  c358 STRING,      
  c359 STRING,      
  c360 STRING,      
  c361 STRING,      
  c362 STRING,      
  c363 STRING,      
  c364 STRING,      
  c365 STRING,      
  c366 STRING,      
  c367 STRING,      
  c368 STRING,      
  c369 STRING,      
  c370 STRING,      
  c371 STRING,      
  c372 STRING,      
  c373 STRING,      
  c374 STRING,      
  c375 STRING,      
  c376 STRING,      
  c377 STRING,      
  c378 STRING,      
  c379 STRING,      
  c380 STRING,      
  c381 STRING,      
  c382 STRING,      
  c383 STRING,      
  c384 STRING,      
  c385 STRING,      
  c386 STRING,      
  c387 STRING,      
  c388 STRING,      
  c389 STRING,      
  c390 STRING,      
  c391 STRING,      
  c392 STRING,      
  c393 STRING,      
  c394 STRING,      
  c395 STRING,      
  c396 STRING,      
  c397 STRING,      
  c398 STRING,      
  c399 STRING,      
  c400 STRING,      
  c401 STRING,      
  c402 STRING,      
  c403 STRING,      
  c404 STRING,      
  c405 STRING,      
  c406 STRING,      
  c407 STRING,      
  c408 STRING,      
  c409 STRING,      
  c410 STRING,      
  c411 STRING,      
  c412 STRING,      
  c413 STRING,      
  c414 STRING,      
  c415 STRING,      
  c416 STRING,      
  c417 STRING,      
  c418 STRING,      
  c419 STRING,      
  c420 STRING,      
  c421 STRING,      
  c422 STRING,      
  c423 STRING,      
  c424 STRING,      
  c425 STRING,      
  c426 STRING,      
  c427 STRING,      
  c428 STRING,      
  c429 STRING,      
  c430 STRING,      
  c431 STRING,      
  c432 STRING,      
  c433 STRING,      
  c434 STRING,      
  c435 STRING,      
  c436 STRING,      
  c437 STRING,      
  c438 STRING,      
  c439 STRING,      
  c440 STRING,      
  c441 STRING,      
  c442 STRING,      
  c443 STRING,      
  c444 STRING,      
  c445 STRING,      
  c446 STRING,      
  c447 STRING,      
  c448 STRING,      
  c449 STRING,      
  c450 STRING,      
  c451 STRING,      
  c452 STRING,      
  c453 STRING,      
  c454 STRING,      
  c455 STRING,      
  c456 STRING,      
  c457 STRING,      
  c458 STRING,      
  c459 STRING,      
  c460 STRING,      
  c461 STRING,      
  c462 STRING,      
  c463 STRING,      
  c464 STRING,      
  c465 STRING,      
  c466 STRING,      
  c467 STRING,      
  c468 STRING,      
  c469 STRING,      
  c470 STRING,      
  c471 STRING,      
  c472 STRING,      
  c473 STRING,      
  c474 STRING,      
  c475 STRING,      
  c476 STRING,      
  c477 STRING,      
  c478 STRING,      
  c479 STRING,      
  c480 STRING,      
  c481 STRING,      
  c482 STRING,      
  c483 STRING,      
  c484 STRING,      
  c485 STRING,      
  c486 STRING,      
  c487 STRING,      
  c488 STRING,      
  c489 STRING,      
  c490 STRING,      
  c491 STRING,      
  c492 STRING,      
  c493 STRING,      
  c494 STRING,      
  c495 STRING,      
  c496 STRING,      
  c497 STRING,      
  c498 STRING,      
  c499 STRING,      
  c500 STRING,      
  c501 STRING,      
  c502 STRING,      
  c503 STRING,      
  c504 STRING,      
  c505 STRING,      
  c506 STRING,      
  c507 STRING,      
  c508 STRING,      
  c509 STRING,      
  c510 STRING,      
  c511 STRING,      
  c512 STRING,      
  c513 STRING,      
  c514 STRING,      
  c515 STRING,      
  c516 STRING,      
  c517 STRING,      
  c518 STRING,      
  c519 STRING,      
  c520 STRING,      
  c521 STRING,      
  c522 STRING,      
  c523 STRING,      
  c524 STRING,      
  c525 STRING,      
  c526 STRING,      
  c527 STRING,      
  c528 STRING,      
  c529 STRING,      
  c530 STRING,      
  c531 STRING,      
  c532 STRING,      
  c533 STRING,      
  c534 STRING,      
  c535 STRING,      
  c536 STRING,      
  c537 STRING,      
  c538 STRING,      
  c539 STRING,      
  c540 STRING,      
  c541 STRING,      
  c542 STRING,      
  c543 STRING,      
  c544 STRING,      
  c545 STRING,      
  c546 STRING,      
  c547 STRING,      
  c548 STRING,      
  c549 STRING,      
  c550 STRING,      
  c551 STRING,      
  c552 STRING,      
  c553 STRING,      
  c554 STRING,      
  c555 STRING,      
  c556 STRING,      
  c557 STRING,      
  c558 STRING,      
  c559 STRING,      
  c560 STRING,      
  c561 STRING,      
  c562 STRING,      
  c563 STRING,      
  c564 STRING,      
  c565 STRING,      
  c566 STRING,      
  c567 STRING,      
  c568 STRING,      
  c569 STRING,      
  c570 STRING,      
  c571 STRING,      
  c572 STRING,      
  c573 STRING,      
  c574 STRING,      
  c575 STRING,      
  c576 STRING,      
  c577 STRING,      
  c578 STRING,      
  c579 STRING,      
  c580 STRING,      
  c581 STRING,      
  c582 STRING,      
  c583 STRING,      
  c584 STRING,      
  c585 STRING,      
  c586 STRING,      
  c587 STRING,      
  c588 STRING,      
  c589 STRING,      
  c590 STRING,      
  c591 STRING,      
  c592 STRING,      
  c593 STRING,      
  c594 STRING,      
  c595 STRING,      
  c596 STRING,      
  c597 STRING,      
  c598 STRING,      
  c599 STRING,      
  c600 STRING,      
  c601 STRING,      
  c602 STRING,      
  c603 STRING,      
  c604 STRING,      
  c605 STRING,      
  c606 STRING,      
  c607 STRING,      
  c608 STRING,      
  c609 STRING,      
  c610 STRING,      
  c611 STRING,      
  c612 STRING,      
  c613 STRING,      
  c614 STRING,      
  c615 STRING,      
  c616 STRING,      
  c617 STRING,      
  c618 STRING,      
  c619 STRING,      
  c620 STRING,      
  c621 STRING,      
  c622 STRING,      
  c623 STRING,      
  c624 STRING,      
  c625 STRING,      
  c626 STRING,      
  c627 STRING,      
  c628 STRING,      
  c629 STRING,      
  c630 STRING,      
  c631 STRING,      
  c632 STRING,      
  c633 STRING,      
  c634 STRING,      
  c635 STRING,      
  c636 STRING,      
  c637 STRING,      
  c638 STRING,      
  c639 STRING,      
  c640 STRING,      
  c641 STRING,      
  c642 STRING,      
  c643 STRING,      
  c644 STRING,      
  c645 STRING,      
  c646 STRING,      
  c647 STRING,      
  c648 STRING,      
  c649 STRING,      
  c650 STRING,      
  c651 STRING,      
  c652 STRING,      
  c653 STRING,      
  c654 STRING,      
  c655 STRING,      
  c656 STRING,      
  c657 STRING,      
  c658 STRING,      
  c659 STRING,      
  c660 STRING,      
  c661 STRING,      
  c662 STRING,      
  c663 STRING,      
  c664 STRING,      
  c665 STRING,      
  c666 STRING,      
  c667 STRING,      
  c668 STRING,      
  c669 STRING,      
  c670 STRING,      
  c671 STRING,      
  c672 STRING,      
  c673 STRING,      
  c674 STRING,      
  c675 STRING,      
  c676 STRING,      
  c677 STRING,      
  c678 STRING,      
  c679 STRING,      
  c680 STRING,      
  c681 STRING,      
  c682 STRING,      
  c683 STRING,      
  c684 STRING,      
  c685 STRING,      
  c686 STRING,      
  c687 STRING,      
  c688 STRING,      
  c689 STRING,      
  c690 STRING,      
  c691 STRING,      
  c692 STRING,      
  c693 STRING,      
  c694 STRING,      
  c695 STRING,      
  c696 STRING,      
  c697 STRING,      
  c698 STRING,      
  c699 STRING,      
  c700 STRING,      
  c701 STRING,      
  c702 STRING,      
  c703 STRING,      
  c704 STRING,      
  c705 STRING,      
  c706 STRING,      
  c707 STRING,      
  c708 STRING,      
  c709 STRING,      
  c710 STRING,      
  c711 STRING,      
  c712 STRING,      
  c713 STRING,      
  c714 STRING,      
  c715 STRING,      
  c716 STRING,      
  c717 STRING,      
  c718 STRING,      
  c719 STRING,      
  c720 STRING,      
  c721 STRING,      
  c722 STRING,      
  c723 STRING,      
  c724 STRING,      
  c725 STRING,      
  c726 STRING,      
  c727 STRING,      
  c728 STRING,      
  c729 STRING,      
  c730 STRING,      
  c731 STRING,      
  c732 STRING,      
  c733 STRING,      
  c734 STRING,      
  c735 STRING,      
  c736 STRING,      
  c737 STRING,      
  c738 STRING,      
  c739 STRING,      
  c740 STRING,      
  c741 STRING,      
  c742 STRING,      
  c743 STRING,      
  c744 STRING,      
  c745 STRING,      
  c746 STRING,      
  c747 STRING,      
  c748 STRING,      
  c749 STRING,      
  c750 STRING,      
  c751 STRING,      
  c752 STRING,      
  c753 STRING,      
  c754 STRING,      
  c755 STRING,      
  c756 STRING,      
  c757 STRING,      
  c758 STRING,      
  c759 STRING,      
  c760 STRING,      
  c761 STRING,      
  c762 STRING,      
  c763 STRING,      
  c764 STRING,      
  c765 STRING,      
  c766 STRING,      
  c767 STRING,      
  c768 STRING,      
  c769 STRING,      
  c770 STRING,      
  c771 STRING,      
  c772 STRING,      
  c773 STRING,      
  c774 STRING,      
  c775 STRING,      
  c776 STRING,      
  c777 STRING,      
  c778 STRING,      
  c779 STRING,      
  c780 STRING,      
  c781 STRING,      
  c782 STRING,      
  c783 STRING,      
  c784 STRING,      
  c785 STRING,      
  c786 STRING,      
  c787 STRING,      
  c788 STRING,      
  c789 STRING,      
  c790 STRING,      
  c791 STRING,      
  c792 STRING,      
  c793 STRING,      
  c794 STRING,      
  c795 STRING,      
  c796 STRING,      
  c797 STRING,      
  c798 STRING,      
  c799 STRING,      
  c800 STRING,      
  c801 STRING,      
  c802 STRING,      
  c803 STRING,      
  c804 STRING,      
  c805 STRING,      
  c806 STRING,      
  c807 STRING,      
  c808 STRING,      
  c809 STRING,      
  c810 STRING,      
  c811 STRING,      
  c812 STRING,      
  c813 STRING,      
  c814 STRING,      
  c815 STRING,      
  c816 STRING,      
  c817 STRING,      
  c818 STRING,      
  c819 STRING,      
  c820 STRING,      
  c821 STRING,      
  c822 STRING,      
  c823 STRING,      
  c824 STRING,      
  c825 STRING,      
  c826 STRING,      
  c827 STRING,      
  c828 STRING,      
  c829 STRING,      
  c830 STRING,      
  c831 STRING,      
  c832 STRING,      
  c833 STRING,      
  c834 STRING,      
  c835 STRING,      
  c836 STRING,      
  c837 STRING,      
  c838 STRING,      
  c839 STRING,      
  c840 STRING,      
  c841 STRING,      
  c842 STRING,      
  c843 STRING,      
  c844 STRING,      
  c845 STRING,      
  c846 STRING,      
  c847 STRING,      
  c848 STRING,      
  c849 STRING,      
  c850 STRING,      
  c851 STRING,      
  c852 STRING,      
  c853 STRING,      
  c854 STRING,      
  c855 STRING,      
  c856 STRING,      
  c857 STRING,      
  c858 STRING,      
  c859 STRING,      
  c860 STRING,      
  c861 STRING,      
  c862 STRING,      
  c863 STRING,      
  c864 STRING,      
  c865 STRING,      
  c866 STRING,      
  c867 STRING,      
  c868 STRING,      
  c869 STRING,      
  c870 STRING,      
  c871 STRING,      
  c872 STRING,      
  c873 STRING,      
  c874 STRING,      
  c875 STRING,      
  c876 STRING,      
  c877 STRING,      
  c878 STRING,      
  c879 STRING,      
  c880 STRING,      
  c881 STRING,      
  c882 STRING,      
  c883 STRING,      
  c884 STRING,      
  c885 STRING,      
  c886 STRING,      
  c887 STRING,      
  c888 STRING,      
  c889 STRING,      
  c890 STRING,      
  c891 STRING,      
  c892 STRING,      
  c893 STRING,      
  c894 STRING,      
  c895 STRING,      
  c896 STRING,      
  c897 STRING,      
  c898 STRING,      
  c899 STRING,      
  c900 STRING,      
  c901 STRING,      
  c902 STRING,      
  c903 STRING,      
  c904 STRING,      
  c905 STRING,      
  c906 STRING,      
  c907 STRING,      
  c908 STRING,      
  c909 STRING,      
  c910 STRING,      
  c911 STRING,      
  c912 STRING,      
  c913 STRING,      
  c914 STRING,      
  c915 STRING,      
  c916 STRING,      
  c917 STRING,      
  c918 STRING,      
  c919 STRING,      
  c920 STRING,      
  c921 STRING,      
  c922 STRING,      
  c923 STRING,      
  c924 STRING,      
  c925 STRING,      
  c926 STRING,      
  c927 STRING,      
  c928 STRING,      
  c929 STRING,      
  c930 STRING,      
  c931 STRING,      
  c932 STRING,      
  c933 STRING,      
  c934 STRING,      
  c935 STRING,      
  c936 STRING,      
  c937 STRING,      
  c938 STRING,      
  c939 STRING,      
  c940 STRING,      
  c941 STRING,      
  c942 STRING,      
  c943 STRING,      
  c944 STRING,      
  c945 STRING,      
  c946 STRING,      
  c947 STRING,      
  c948 STRING,      
  c949 STRING,      
  c950 STRING,      
  c951 STRING,      
  c952 STRING,      
  c953 STRING,      
  c954 STRING,      
  c955 STRING,      
  c956 STRING,      
  c957 STRING,      
  c958 STRING,      
  c959 STRING,      
  c960 STRING,      
  c961 STRING,      
  c962 STRING,      
  c963 STRING,      
  c964 STRING,      
  c965 STRING,      
  c966 STRING,      
  c967 STRING,      
  c968 STRING,      
  c969 STRING,      
  c970 STRING,      
  c971 STRING,      
  c972 STRING,      
  c973 STRING,      
  c974 STRING,      
  c975 STRING,      
  c976 STRING,      
  c977 STRING,      
  c978 STRING,      
  c979 STRING,      
  c980 STRING,      
  c981 STRING,      
  c982 STRING,      
  c983 STRING,      
  c984 STRING,      
  c985 STRING,      
  c986 STRING,      
  c987 STRING,      
  c988 STRING,      
  c989 STRING,      
  c990 STRING,      
  c991 STRING,      
  c992 STRING,      
  c993 STRING,      
  c994 STRING,      
  c995 STRING,      
  c996 STRING,      
  c997 STRING,      
  c998 STRING,      
  c999 STRING,      
  c1000 STRING                                                 
)                                                              
STORED AS PARQUET                                              
LOCATION '/user/hive/warehouse/scan_primitives_tpch_3tb.db/wide_parquet_1000_small'
{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message