Todd McGrath tmcgrath
tmcgrath
/ connect-file-source.json
Last active
May 14, 2020 18:41
A JSON file example for Kafka Connect File Source used in tutorial at https://supergloo.com/kafka-connect/running-kafka-connect-standalone-vs-distributed-mode-examples/
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
| { | |
| "name": "local-file-source", | |
| "config": { | |
| "connector.class":"FileStreamSource", | |
| "tasks.max":"1", | |
| "file":"test.txt", | |
| "topic":"connect-test" | |
| } | |
| } |
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
| # Based on | |
| # https://natelandau.com/my-mac-osx-bash_profile/ | |
| # --------------------------------------------------------------------------- | |
| # | |
| # Description: This file holds all my BASH configurations and aliases | |
| # | |
| # Sections: | |
| # 1. Environment Configuration | |
| # 2. Make Terminal Better (remapping defaults and adding functionality) | |
| # 3. File and Folder Management |
tmcgrath
/ SparkSQL with json example
Created
December 8, 2016 13:43
SparkSQL with json file example
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
| // download sample json | |
| http://bit.ly/2gY39Ay | |
| // start spark-shell in same directory as where customers.json | |
| // is downloaded | |
| val customers = sqlContext.jsonFile("customers.json") | |
| // register a temp table | |
| customers.registerTempTable("customers") |
tmcgrath
/ Cassandra Spark SQL
Created
December 8, 2016 13:35
SparkSQL with Cassandra from Killrweather processed data
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
| //If you want to run a local cluster | |
| //start-master.sh | |
| //start-slave.sh <your-master-url> | |
| // connect to spark-shell and load cassandra connector jar OR | |
| ~/Development/spark-1.6.3-bin-hadoop2.6/bin/spark-shell --packages datastax:spark-cassandra-connector:1.6.0-s_2.10 | |
| // connect to spark-shell to spark cluster and load cassandra connector jar | |
| ~/Development/spark-1.6.3-bin-hadoop2.6/bin/spark-shell --master <your-master-url> --packages datastax:spark-cassandra-connector:1.6.0-s_2.10 |
tmcgrath
/ Cassandra Join
Created
December 8, 2016 13:28
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
| //If you want to run a local cluster | |
| //start-master.sh | |
| //start-slave.sh <your-master-url> | |
| // connect to spark-shell and load cassandra connector jar OR | |
| ~/Development/spark-1.6.3-bin-hadoop2.6/bin/spark-shell --packages datastax:spark-cassandra-connector:1.6.0-s_2.10 | |
| // connect to spark-shell to spark cluster and load cassandra connector jar | |
| ~/Development/spark-1.6.3-bin-hadoop2.6/bin/spark-shell --master <your-master-url> --packages datastax:spark-cassandra-connector:1.6.0-s_2.10 |
tmcgrath
/ 0_reuse_code.js
Created
June 1, 2016 21:04
Here are some things you can do with Gists in GistBox.
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
| // Use Gists to store code you would like to remember later on | |
| console.log(window); // log the "window" object to the console |
tmcgrath
/ Spark SQL with Scala using mySQL (JDBC) data source
Created
January 6, 2016 17:32
Using Spark Console, connect and query a mySQL database. This is applicable to any database with JDBC driver though
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
| todd-mcgraths-macbook-pro:spark-1.4.1-bin-hadoop2.4 toddmcgrath$ bin/spark-shell --jars mysql-connector-java-5.1.38-bin.jar | |
| Welcome to | |
| ____ __ | |
| / __/__ ___ _____/ /__ | |
| _\ \/ _ \/ _ `/ __/ '_/ | |
| /___/ .__/\_,_/_/ /_/\_\ version 1.4.1 | |
| /_/ | |
| Using Scala version 2.10.4 (Java HotSpot(TM) 64-Bit Server VM, Java 1.8.0_66) | |
| Type in expressions to have them evaluated. |
tmcgrath
/ Spark SQL with valid JSON input source
Created
January 6, 2016 17:08
Spark SQL with Scala using valid JSON input source example in Spark Console
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
| todd-mcgraths-macbook-pro:spark-1.4.1-bin-hadoop2.4 toddmcgrath$ bin/spark-shell | |
| 2016-01-06 11:05:57.362 java[30505:1203] Unable to load realm info from SCDynamicStore | |
| Welcome to | |
| ____ __ | |
| / __/__ ___ _____/ /__ | |
| _\ \/ _ \/ _ `/ __/ '_/ | |
| /___/ .__/\_,_/_/ /_/\_\ version 1.4.1 | |
| /_/ | |
| Using Scala version 2.10.4 (Java HotSpot(TM) 64-Bit Server VM, Java 1.6.0_65) |
tmcgrath
/ Spark SQL with invalid JSON input source
Last active
January 6, 2016 17:07
Happy Path Spark SQL with JSON input source
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
| todd-mcgraths-macbook-pro:spark-1.4.1-bin-hadoop2.4 toddmcgrath$ bin/spark-shell | |
| 2016-01-06 10:54:58.540 java[25147:1203] Unable to load realm info from SCDynamicStore | |
| Welcome to | |
| ____ __ | |
| / __/__ ___ _____/ /__ | |
| _\ \/ _ \/ _ `/ __/ '_/ | |
| /___/ .__/\_,_/_/ /_/\_\ version 1.4.1 | |
| /_/ | |
| Using Scala version 2.10.4 (Java HotSpot(TM) 64-Bit Server VM, Java 1.6.0_65) |
tmcgrath
/ Spark SQL CSV repl session
Created
January 6, 2016 16:48
Spark SQL with Scala using CSV input data source in spark console
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
| todd-mcgraths-macbook-pro:spark-1.4.1-bin-hadoop2.4 toddmcgrath$ bin/spark-shell --packages com.databricks:spark-csv_2.10:1.3.0 | |
| Ivy Default Cache set to: /Users/toddmcgrath/.ivy2/cache | |
| The jars for the packages stored in: /Users/toddmcgrath/.ivy2/jars | |
| :: loading settings :: url = jar:file:/Users/toddmcgrath/Development/spark-1.4.1-bin-hadoop2.4/lib/spark-assembly-1.4.1-hadoop2.4.0.jar!/org/apache/ivy/core/settings/ivysettings.xml | |
| com.databricks#spark-csv_2.10 added as a dependency | |
| :: resolving dependencies :: org.apache.spark#spark-submit-parent;1.0 | |
| confs: [default] | |
| found com.databricks#spark-csv_2.10;1.3.0 in central | |
| found org.apache.commons#commons-csv;1.1 in central | |
| found com.univocity#univocity-parsers;1.5.1 in central |
NewerOlder