Skip to content

Instantly share code, notes, and snippets.

View nileema's full-sized avatar

Nileema Shingte nileema

106 followers · 14 following
View GitHub Profile
@nileema
nileema / gist:9cad3eb432f3a41adf60
Created August 28, 2015 14:19
" 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
nileema / gist:a0683bac86fb71216020
Created August 28, 2015 06:23
// 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
nileema / gist:9346f484359e39a52c21
Created August 7, 2015 05:22
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
nileema / gist:b0e7635465bf7d4bdf45
Created July 30, 2015 17:13
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
nileema / raptor-update.sql
Created July 27, 2015 18:26
ALTER TABLE tables DROP COLUMN catalog_name;
ALTER TABLE views DROP COLUMN catalog_name;
@nileema
nileema / gist:1baf0bbfeb5974ccd02f
Created October 31, 2014 23:29
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
nileema / gist:2010aa90023dc0cce6d8
Created October 31, 2014 21:34
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
nileema / gist:58e08ef66aed0c3209ef
Created October 31, 2014 20:40
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
nileema / gist:40e15f72ce5c7fd2e2d0
Created October 31, 2014 04:35
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
nileema / gist:93c5dc94f8ee63b2cf72
Created October 31, 2014 04:32
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