Nileema Shingte nileema
nileema
/ gist:9cad3eb432f3a41adf60
Created
August 28, 2015 14:19
This file contains hidden or 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
| " display | |
| set helpheight=50 " default help height | |
| set nolist " show/hide tabs and EOL chars | |
| set number " show/hide line numbers (nu/nonu) | |
| set scrolloff=5 " scroll offsett, min lines above/below cursor | |
| set scrolljump=5 " jump 5 lines when running out of the screen | |
| set sidescroll=10 " minumum columns to scroll horizontally | |
| set backspace=indent,start,eol " repair wired terminal/vim settings ??? | |
| set showcmd " show command status | |
| set showmatch " jump to matching bracket char when iserting |
nileema
/ gist:a0683bac86fb71216020
Created
August 28, 2015 06:23
This file contains hidden or 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
| // Install CTRL-P | |
| git clone https://github.com/kien/ctrlp.vim.git ~/.vim/bundle/ctrlp.vim | |
| // Add this to vimrc | |
| """"""""""" | |
| " CTRL P | |
| """""""""" | |
| set runtimepath^=~/.vim/bundle/ctrlp.vim | |
| " Set no max file limit | |
| let g:ctrlp_max_files = 0 |
nileema
/ gist:9346f484359e39a52c21
Created
August 7, 2015 05:22
This file contains hidden or 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
| java.lang.NullPointerException | |
| at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22) | |
| at com.facebook.presto.sql.planner.LogicalPlanner.createRelationPlan(LogicalPlanner.java:191) | |
| at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:84) | |
| at com.facebook.presto.sql.analyzer.QueryExplainer.getLogicalPlan(QueryExplainer.java:98) | |
| at com.facebook.presto.sql.analyzer.QueryExplainer.getPlan(QueryExplainer.java:60) | |
| at com.facebook.presto.sql.analyzer.StatementAnalyzer.getQueryPlan(StatementAnalyzer.java:498) | |
| at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitExplain(StatementAnalyzer.java:479) | |
| at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitExplain(StatementAnalyzer.java:114) | |
| at com.facebook.presto.sql.tree.Explain.accept(Explain.java:54) |
nileema
/ gist:b0e7635465bf7d4bdf45
Created
July 30, 2015 17:13
This file contains hidden or 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
| presto:default> select * from fbraptor.metadata.shards where table_name = 'foo_ts'; | |
| schema_name | table_name | shard_uuid | uncompressed_size | compressed_size | row_count | min_timestamp | max_timestamp | |
| -------------+------------+--------------------------------------+-------------------+-----------------+-----------+--------------------------+------------------------- | |
| default | foo_ts | dcbc4761-f5f4-4ef4-af55-2c8c5a179b6f | 25 | 529 | 1 | 47532-06-04 17:56:40.000 | 2015-07-25 01:01:01.000 | |
| (1 row) |
nileema
/ raptor-update.sql
Created
July 27, 2015 18:26
This file contains hidden or 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
| ALTER TABLE tables DROP COLUMN catalog_name; | |
| ALTER TABLE views DROP COLUMN catalog_name; |
nileema
/ gist:1baf0bbfeb5974ccd02f
Created
October 31, 2014 23:29
This file contains hidden or 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 (channelCount) (groupCount) (hashEnabled) Mode Samples Score Score error Units | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 2 true thrpt 30 21.228 0.560 ops/s | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 2 false thrpt 30 14.329 0.653 ops/s | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 10 true thrpt 30 20.145 0.243 ops/s | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 10 false thrpt 30 13.415 0.221 ops/s | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 100 true thrpt 30 18.860 0.224 ops/s | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 100 false thrpt 30 11.555 0.311 ops/s | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 1000 true thr |
nileema
/ gist:2010aa90023dc0cce6d8
Created
October 31, 2014 21:34
This file contains hidden or 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 (channelCount) (groupCount) (hashEnabled) Mode Samples Score Score error Units | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 2 true thrpt 15 0.019 0.001 ops/ms | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 2 false thrpt 15 0.013 0.001 ops/ms | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 10 true thrpt 15 0.019 0.001 ops/ms | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 10 false thrpt 15 0.013 0.001 ops/ms | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 100 true thrpt 15 0.018 0.001 ops/ms | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 100 false thrpt 15 0.011 0.001 ops/ms | |
| c.f.p.o.BenchmarkGroupByHash.runBenchmark 2 1000 true thr |
nileema
/ gist:58e08ef66aed0c3209ef
Created
October 31, 2014 20:40
This file contains hidden or 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 (channelCount) (hashEnabled) Mode Samples Score Score error Units | |
| c.f.p.BenchmarkHashPagePartitionFunction.runBenchmark 2 true thrpt 9 0.061 0.005 ops/ms | |
| c.f.p.BenchmarkHashPagePartitionFunction.runBenchmark 2 false thrpt 9 0.030 0.009 ops/ms | |
| c.f.p.BenchmarkHashPagePartitionFunction.runBenchmark 5 true thrpt 9 0.095 0.012 ops/ms | |
| c.f.p.BenchmarkHashPagePartitionFunction.runBenchmark 5 false thrpt 9 0.013 0.005 ops/ms | |
| c.f.p.BenchmarkHashPagePartitionFunction.runBenchmark 10 true thrpt 9 0.094 0.026 ops/ms | |
| c.f.p.BenchmarkHashPagePartitionFunction.runBenchmark 10 false thrpt 9 0.028 0.010 ops/ms | |
| c.f.p.BenchmarkHashPagePartitionFunction.runBenchmark 15 true thrpt 9 0.0 |
nileema
/ gist:40e15f72ce5c7fd2e2d0
Created
October 31, 2014 04:35
This file contains hidden or 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
| WithoutHash_channels_1 38.45ms | |
| WithoutHash_channels_2 72.90ms | |
| WithoutHash_channels_3 40.35ms | |
| WithoutHash_channels_4 67.26ms | |
| WithoutHash_channels_5 28.08ms | |
| WithoutHash_channels_6 71.23ms | |
| WithoutHash_channels_7 58.33ms | |
| WithoutHash_channels_8 67.60ms | |
| WithoutHash_channels_9 27.95ms | |
| WithoutHash_channels_10 73.18ms |
nileema
/ gist:93c5dc94f8ee63b2cf72
Created
October 31, 2014 04:32
This file contains hidden or 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
| WithoutHash__channels_2__groups_1 87.30ms | |
| WithoutHash__channels_3__groups_1 90.09ms | |
| WithoutHash__channels_4__groups_1 72.55ms | |
| WithoutHash__channels_5__groups_1 77.22ms | |
| WithoutHash__channels_6__groups_1 68.59ms | |
| WithoutHash__channels_7__groups_1 70.64ms | |
| WithoutHash__channels_8__groups_1 70.24ms | |
| WithoutHash__channels_9__groups_1 80.80ms | |
| WithoutHash__channels_10__groups_1 92.15ms | |
| WithoutHash__channels_2__groups_2 77.79ms |