Nileema Shingte nileema
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: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
/ 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: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: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:2ab37581cfa9e09bcac1
Last active
April 8, 2018 02:09
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
| """"""""""""""""""""""""" | |
| " Vundle | |
| """"""""""""""""""""""""" | |
| " set the runtime path to include Vundle and initialize | |
| set rtp+=~/.vim/bundle/Vundle.vim | |
| call vundle#begin() | |
| " alternatively, pass a path where Vundle should install plugins | |
| "call vundle#begin('~/some/path/here') | |
| " let Vundle manage Vundle, required |
nileema
/ gist:f67c70b8d75f5f7b8e0a
Last active
April 8, 2018 02:09
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:tiny> explain (type distributed) | |
| select * from | |
| (select orderkey + 1 orderkey from orders) o | |
| join | |
| (select orderkey + 1 orderkey from orders) o1 | |
| on (o.orderkey = o1.orderkey); | |
| Query Plan | |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| Fragment 0 [SINGLE] |
nileema
/ gist:96943fab53f6f16c0af8
Last active
April 8, 2018 02:09
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:tiny> explain (type distributed) | |
| select * from (select orderkey, mod(orderkey,3) from orders) o | |
| join | |
| (select orderkey, mod(orderkey, 3) from orders) o1 | |
| on (o.orderkey = o1.orderkey); | |
| Query Plan | |
| ---------------------------------------------------------------------------------------------------------------------------------------- | |
| Fragment 0 [SINGLE] | |
| Output layout: [orderkey, mod, orderkey_6, mod_17] | |
| - Output[orderkey, len, orderkey, len] => [orderkey:bigint, mod:bigint, orderkey_6:bigint, mod_17:bigint] |
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
| select * | |
| FROM | |
| (select orderkey, count(*) from orders group by orderkey) a | |
| JOIN | |
| (select orderkey, count(*) from lineitem group by orderkey) b | |
| on a.orderkey = b.orderkey | |
| Query Plan | |
| --------------------------------------------------------------------------------------------------------------------------------------------- | |
| Fragment 0 [SINGLE] |
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
| at com.facebook.presto.raptor.util.DatabaseUtil.metadataError(DatabaseUtil.java:67) | |
| at com.facebook.presto.raptor.metadata.ShardIterator.computeNext(ShardIterator.java:101) | |
| at com.facebook.presto.raptor.metadata.ShardIterator.computeNext(ShardIterator.java:48) | |
| at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:143) | |
| at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:138) | |
| at com.facebook.presto.raptor.util.SynchronizedResultIterator.hasNext(SynchronizedResultIterator.java:41) | |
| at com.facebook.presto.raptor.RaptorSplitManager$RaptorSplitSource.isFinished(RaptorSplitManager.java:179) | |
| at com.facebook.presto.split.ConnectorAwareSplitSource.isFinished(ConnectorAwareSplitSource.java:59) | |
| at com.facebook.presto.execution.scheduler.SourcePartitionedScheduler.schedule(SourcePartitionedScheduler.java:76) | |
| at com.facebook.presto.execution.scheduler.SqlQueryScheduler.schedule(SqlQueryScheduler.java:304) |