vlsi

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

vlsi

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) {

vlsi

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)

vlsi

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

vlsi

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.

vlsi

$ 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:

vlsi

# Run complete. Total time: 00:00:05

Benchmark                                                                  Mode    Cnt     Score     Error   Units
HotspotAllocationProfilerTest.allocateObject                               avgt            4,297             ns/op
HotspotAllocationProfilerTest.allocateObject:·allocated                    avgt           16,002              B/op
HotspotAllocationProfilerTest.allocateObject:·allocation.rate              avgt         3202,343            MB/sec
HotspotAllocationProfilerTest.allocateObjectSampleTime                   sample  15583    56,291 ±   3,064   ns/op
HotspotAllocationProfilerTest.allocateObjectSampleTime:·allocated        sample           16,001              B/op
HotspotAllocationProfilerTest.allocateObjectSampleTime:·allocation.rate  sample         1941,053            MB/sec
HotspotAllocationProfilerTest.allocateObjectSingleShot                       ss      5  1287,800 ± 302,336   ns/op

vlsi

 Benchmark                                           Mode  Cnt      Score        Error
FinalizeStatement.createAndLeak                      avgt    2    OutOfMemoryError at iteration 3
FinalizeStatement.createAndLeak:·gc.alloc.rate.norm  avgt    2    192,026

vlsi

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

vlsi

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) {