We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 24 columns, instead of 1. in line 4.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
GPMLHTLN,TWBBEUVGM,KZ.GPGLB,CC.NVZUPRFF,NR.LEI,VA.TEXK.SCS,AN.GJTH.CRQ,UCEXFMDT,YVYB,HKSGOOSB.TF,LPBE.KE,BKJKNT,HL.DGTVRM,UZPA.XRTY.P,IYFV.ARGD.O,DHYJ.ZM.Y,GAPV.NP.U,ND.EITRXCL,OL.KYHGHYN,EI.YCOTJA,HC.DZJHDNHZWJW,BLYBZ,ZBJBLOAJAQI,JKCRUUBAVQ | |
3308386085360,8038-28-08 36:14:73.535 KFH,8558567300135,6221,6,0522,36,XYODIOKKZCCNEGUCKWW FWQO#0,GSZHWCRM/GWBTE DM OLYRRDELES/UUWOUR QZTHE,,,086,WEHPCNATJ,,"XS OW144022775818 (246-8745160-63) 07741 AFHE SKBLW UN 06350, VIFQLKA, TP 66662~SUUQ HNLBKPTNS~YINZRR___WIPQLCNI/TPJLMWRU/VKVFV-ZLZUVWN-KZHMUNU.ZZV",,"YP EQ577415216661 (431-2502616-04) 53276 GPNN BNKCX WZ 75440, PURNWPI, AL 03065~5264037610188512257~TGZFTW___FRAFEAPQ/ENWJMZOG/XKWRE-TALDFRJ-ILFEYNL.JVA",,,,,0,LHCYS AYE ZLEMYA IFU HEI JG FEYE, | |
7417870277687,0546-33-45 86:27:47.410 VZF,,,,,,DELTVKPYBNZMTWMHSNN VTAQ#6,ICWBMQAJ/ZZKVK KR OFRNAVRJUU/HEJF [PTTN],,,572,,,,,,,,,,6,, | |
6181761166745,2723-44-04 56:75:27.000 BGY,,,,,,QGDKGXPBAFCKWKMXOAV XVKD#5,QCYYFYJU/JKAKA IH QXOZHEEYDJ/KHPU [OXPJQHJW],,,650,,,,,,,,,,3,, | |
0874335 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
require(data.table) | |
N=3 #servers | |
l=86400 # interval | |
s=90 # gc duration | |
m=1000000 # samples | |
# Here we calculate "intersection of N intervals in each m groups independently" | |
# This is much faster than trying to do 'm' iterations of "intersect N intervals". | |
num_of_all_in_gc_cases <- function(d) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select * | |
from (select 2+pPartkey pPartkey, 3+pPartkey pPartkey2 from part) p | |
where | |
exists ( | |
select 1 | |
from (select psPartkey+1 psPartkey from partsupp) ps | |
where psPartkey=p.pPartkey2 | |
and exists ( | |
select 2 | |
from (select psPartkey+3 p3, psPartkey+4 p4, psPartkey+5 p5 from partsupp) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
bash-3.2$ mvn install | |
[INFO] Scanning for projects... | |
[INFO] | |
[INFO] ------------------------------------------------------------------------ | |
[INFO] Building calite-map-demo 0.0.1-SNAPSHOT | |
[INFO] ------------------------------------------------------------------------ | |
[INFO] | |
[INFO] --- scala-maven-plugin:3.1.6:add-source (scala-compile-first) @ calite-map-demo --- | |
[INFO] Add Source directory: /Users/vladimirsitnikov/Documents/work/calcite-map-demo/src/main/scala | |
[INFO] Add Test Source directory: /Users/vladimirsitnikov/Documents/work/calcite-map-demo/src/test/scala |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Repeated executions of "mvn install -DskipTests -Dcheckstyle.skip=true" of | |
https://github.com/apache/incubator-calcite | |
with <useIncrementalCompilation>false</useIncrementalCompilation> are _faster_ than in default mode. | |
It looks like the setting is inversed somehow. | |
The issue is described here: | |
http://stackoverflow.com/questions/17944108/maven-compiler-plugin-always-detecting-a-set-of-sources-as-stale | |
https://jira.codehaus.org/browse/MCOMPILER-209 | |
No "Compiling ... source files to..." messages during the build. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ sudo java -jar jol-cli-0.3-full.jar externals java.util.concurrent.CopyOnWriteArrayList | |
Running 64-bit HotSpot VM. | |
Using compressed oop with 3-bit shift. | |
Using compressed klass with 3-bit shift. | |
Objects are 8 bytes aligned. | |
Field sizes by type: 4, 1, 1, 2, 2, 4, 4, 8, 8 [bytes] | |
Array element sizes: 4, 1, 1, 2, 2, 4, 4, 8, 8 [bytes] | |
objc[33686]: Class JavaLaunchHelper is implemented in both /Library/Java/JavaVirtualMachines/jdk1.8.0_40.jdk/Contents/Home/bin/java and /Library/Java/JavaVirtualMachines/jdk1.8.0_40.jdk/Contents/Home/jre/lib/libinstrument.dylib. One of the two will be used. Which one is undefined. | |
java.util.concurrent.CopyOnWriteArrayList object externals: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Benchmark Mode Cnt Score Error | |
FinalizeStatement.createAndLeak avgt 2 OutOfMemoryError at iteration 3 | |
FinalizeStatement.createAndLeak:·gc.alloc.rate.norm avgt 2 192,026 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
The goal is to make the following query perform an index range scan z_line_items on item_id column, | |
then broadcast the results to the slaves that would join z_orders table and check the order type. | |
Even though line_item scan is serial, the join of orders should go in parallel. | |
Oracle DB 11g is required. In Oracle 12c just adding parallel(n) is sufficient. | |
select sum(li.price) | |
from z_line_items li | |
, z_orders o |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.time.Duration; | |
import java.util.Optional; | |
public class Jre7Test { | |
public static class MyClass { | |
public Optional<Duration> optional(java.time.Duration duration) { | |
return Optional.of(duration); | |
} | |
public void say(String greeting) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# i7-4960HQ CPU @ 2.60GHz, jdk1.8.0_51 | |
Benchmark Mode Cnt Score Error Units | |
ControlFlowExceptionBenchmark.baseline avgt 10 8,434 ± 0,374 ns/op | |
ControlFlowExceptionBenchmark.baseline:·gc.alloc.rate avgt 10 0,002 ± 0,006 MB/sec | |
ControlFlowExceptionBenchmark.baseline:·gc.alloc.rate.norm avgt 10 ≈ 10⁻⁵ B/op | |
ControlFlowExceptionBenchmark.baseline:·gc.count avgt 10 ≈ 0 counts | |
ControlFlowExceptionBenchmark.nonWritable avgt 10 16,805 ± 1,247 ns/op | |
ControlFlowExceptionBenchmark.nonWritable:·gc.alloc.rate avgt 10 909,666 ± 61,399 MB/sec | |
ControlFlowExceptionBenchmark.nonWritable:·gc.alloc.rate.norm avgt 10 16,000 ± 0,003 B/op | |
ControlFlowExceptionBenchmark.nonWritable:·gc.churn.PS_Eden_Space avgt 10 90 |
OlderNewer