Gui Braccialli gbraccialli
gbraccialli
/ find_class_in_jars.sh
Last active
December 1, 2015 20:44
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
| #find . -name "*.jar" | while read filename; do echo $filename; jar tf $filename | grep CLASS_NAME_YOU_ARE_LOOKING_FOR; done | |
| find . -name "*.jar" | while read filename; do echo $filename; jar tf $filename | grep $1; done |
gbraccialli
/ sandbox_increase_yarn_and_container_size.sh
Last active
November 30, 2015 22: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
| #curl -sSL https://gist.githubusercontent.com/gbraccialli/16c7f14e9370548db873/raw/ | sudo -E sh | |
| /var/lib/ambari-server/resources/scripts/configs.sh -u admin -p admin set localhost Sandbox yarn-site "yarn.nodemanager.resource.memory-mb" "5000" | |
| /var/lib/ambari-server/resources/scripts/configs.sh -u admin -p admin set localhost Sandbox hive-site "hive.tez.container.size" "500" | |
| /var/lib/ambari-server/resources/scripts/configs.sh -u admin -p admin set localhost Sandbox hive-site "hive.tez.java.opts" "-server -Xmx400m -Djava.net.preferIPv4Stack=true" | |
| curl -u admin:admin -H 'X-Requested-By: ambari' -X POST -d \ | |
| '{ | |
| "RequestInfo":{ | |
| "command":"RESTART", |
gbraccialli
/ hive_simple_csv.sql
Last active
January 20, 2016 13:12
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
| drop table simple_csv; | |
| create external table simple_csv( | |
| field1 string, | |
| field2 string, | |
| field3 string, | |
| field4 string, | |
| field5 string, | |
| field6 string, | |
| field7 string, |
gbraccialli
/ hive_grant.sql
Created
December 1, 2015 15:42
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
| grant select on table sample_08 to group group2; | |
gbraccialli
/ atlas_search.txt
Last active
May 9, 2017 17:16
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
| hive_table | |
| hive_table where name="default.sample_07@Sandbox" | |
| from hive_table where name='default.sample_07@Sandbox',columns | |
| hive_table where name="default.hortondrivers@Sandbox" | |
| 1) hive_db where name = 'default' (Selecting the database knowing the name of the database) | |
| 2) hive_table where name='default.table_1@cluster1' (Selecting the table knowing the name of the table) | |
| 3) hive_table where name='db2.tab4@cluster1' select owner,name,createTime,comment,tableType (selecting attributes of a table) | |
| 4) from hive_table where name='default.table_1@cluster1',columns (listing all the columns of the table) | |
| 5) hive_table where db.name = 'default' (listing all tables in the database ) |
gbraccialli
/ virtualbox_sandbox_staticip.txt
Last active
December 1, 2015 20:07
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
| vi /etc/sysconfig/network-scripts/ifcfg-eth1 | |
| DEVICE=eth1 | |
| BOOTPROTO=none | |
| NETMASK=255.255.255.0 | |
| TYPE=Ethernet | |
| IPADDR=192.168.56.101 | |
| IPV6INIT=no | |
| ONBOOT=yes | |
| USERCTL=no |
gbraccialli
/ sandbox_utils.sh
Last active
December 7, 2015 14:06
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
| #curl -sSL https://gist.githubusercontent.com/gbraccialli/11077c495a7954b597cd/raw/ | sudo -E sh | |
| wget https://gist.githubusercontent.com/gbraccialli/16c7f14e9370548db873/raw/ -O /root/sandbox_increase_yarn_and_container_size.sh | |
| wget https://gist.githubusercontent.com/gbraccialli/07536da4261102588def/raw/ -O /root/find_class_in_jars.sh | |
| wget https://gist.githubusercontent.com/gbraccialli/14c8ca4922bf0c1758ff/raw/ -O /root/phoenix.sh | |
| wget https://gist.githubusercontent.com/gbraccialli/318d28a1a14aff4738db/raw/ -O /root/yarnkillall.sh | |
| wget https://gist.githubusercontent.com/gbraccialli/15d0787cce1aab37b316/raw/ -O /root/ls_to_comma_delimited_variable.sh | |
| wget https://gist.githubusercontent.com/gbraccialli/4d2bbd5534edd49ec97d/raw/ -O /root/beeline.sh | |
| wget https://gist.githubusercontent.com/gbraccialli/014321fb4e3dc465b395/raw/ -O /root/kafka_delete_topic.sh | |
| wget https://gist.githubusercontent.com/gbraccialli/a707dbe62fbc461aed9a/raw/ -O /root/sample_phoenix_hive.sh |
gbraccialli
/ sample_phoenix_hive.sh
Created
December 1, 2015 22:33
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
| sudo -u hdfs hadoop fs -mkdir /user/root | |
| sudo -u hdfs hadoop fs -chmod -R 777 /user/root | |
| mkdir /usr/hdp/current/hive-client/auxlib | |
| cp /usr/hdp/current/phoenix-client/phoenix-server.jar /usr/hdp/current/hive-client/auxlib | |
| chmod -R +x /usr/hdp/current/hive-client/auxlib/ | |
| echo "drop table if exists phoenix_test; | |
| CREATE TABLE PHOENIX_TEST( | |
| ID VARCHAR not null, | |
| TEXT VARCHAR |
gbraccialli
/ update_zeppelin_gallery.sh
Created
December 1, 2015 22:46
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
| curl -sSL https://raw.githubusercontent.com/hortonworks-gallery/zeppelin-notebooks/master/update_all_notebooks.sh | sudo -u zeppelin -E sh |
gbraccialli
/ get_nmon.sh
Last active
February 2, 2017 17: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
| #curl -sSL https://gist.githubusercontent.com/gbraccialli/ba2b8586c5a69dce3d97/raw/ | sudo -E sh | |
| wget http://sourceforge.net/projects/nmon/files/nmon_x86_64_centos6 | |
| cp nmon_x86_64_centos6 /usr/bin/nmon | |
| chmod +x /usr/bin/nmon | |
| nmon_x86_64_centos6 -f -s 1 -t -T -c 100000000000000000000000 |