Anjaiah Methuku anjijava16
anjijava16
/ .zprofile
Created
July 31, 2022 02: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
| welcome@Anjaiahs-MacBook-Pro ~ % more .zprofile | |
| # Setting PATH for Python 3.8 | |
| # The original version is saved in .zprofile.pysave | |
| PATH="/Library/Frameworks/Python.framework/Versions/3.8/bin:${PATH}" | |
| export PATH | |
| welcome@Anjaiahs-MacBook-Pro ~ % |
anjijava16
/ csv_to_csv.py
Created
July 28, 2022 13: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
| import csv | |
| from datetime import datetime | |
| INPUT_FILE_PATH = 'C:/Tech_Learn_welcome/Python_Utils/FastAPI/sai_workspace/fast_api_welcome/files/input.csv' | |
| OUTPUT_FILE_PATH = 'C:/data/python_output/input.csv' | |
| HEADER_SKIP = True | |
| OUTPUT_HEADER = 'id,first,last,ssn,address,firstname_lastname,process_date' | |
| def read_file(): |
anjijava16
/ Python_environment.py
Created
June 25, 2022 04:47
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
| mkdir delab_f | |
| cd delab_f | |
| python3 -m venv delab-venv | |
| source delab-venv/bin/activate | |
| pip install jupyterlab |
anjijava16
/ cosmosdb_azure.scala
Created
January 18, 2022 00:59
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
| # Read data | |
| dfCustomer = spark.read\ | |
| .format("cosmos.oltp")\ | |
| .option("spark.synapse.linkedService", "AdventureWorksSQL")\ | |
| .option("spark.cosmos.container", "Customer")\ | |
| .load() | |
| display(dfCustomer.limit(10)) | |
| # Write data |
anjijava16
/ Spark_Cosmosdb_cassandra.scala
Last active
December 27, 2021 17: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
| # Spark Streaming with Cassandra (Azure Cosmos DB) | |
| 1. https://github.com/mspnp/azure-databricks-streaming-analytics |
anjijava16
/ HASHROW, HASHBUCKET, HASHAMP in Teradata
Last active
December 21, 2021 04:24
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
| 1.http://www.teradatahelp.com/2010/09/how-can-you-view-data-distribution-in.html | |
| 1. http://rajgopal-gurrapushala.blogspot.com/2012/11/types-of-hash-functions-used-in-teradata_734.html | |
| Create Table emp | |
| ( | |
| ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY | |
| (START WITH 1 | |
| INCREMENT BY 1 | |
| MINVALUE -999999999999999999 |
anjijava16
/ azure_synpase_cosmos_db.json
Created
December 20, 2021 04:08
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
| { | |
| "_id" : "F0FF0BA8-CEF4-454C-9173-FA7C546F7179", | |
| "customerId" : "A852CB99-DAA1-4348-A86F-622D4478A7D0", | |
| "orderDate" : "2013-07-11T00:00:00", | |
| "shipDate" : "2013-07-18T00:00:00", | |
| "details" : [ | |
| { | |
| "sku" : "LJ-0192-M", | |
| "name" : "Long-Sleeve Logo Jersey, M", | |
| "price" : 49.99, |
anjijava16
/ any_sql_scripts_run.java
Last active
November 25, 2021 06:11
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
| package com.iwinner.runanysql; | |
| import java.io.BufferedReader; | |
| import java.io.FileReader; | |
| import java.io.Reader; | |
| import java.sql.Connection; | |
| import java.sql.DriverManager; | |
| import java.sql.ResultSet; | |
| import java.sql.SQLException; | |
| import java.sql.Statement; |
anjijava16
/ Logging.json
Created
July 23, 2021 13: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
| { | |
| insertId: "wr3zn3e373bw" | |
| logName: "projects/iwinner-data-318822/logs/cloudaudit.googleapis.com%2Factivity" | |
| operation: { | |
| first: true | |
| id: "operation-1627046240424-5c7ca39319163-07a56cfa-f16ec9a5" | |
| producer: "compute.googleapis.com" | |
| } | |
| protoPayload: { | |
| @type: "type.googleapis.com/google.cloud.audit.AuditLog" |
anjijava16
/ Algorthims.sh
Created
July 21, 2021 03: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
| https://morioh.com/p/4d9c2c2cb9ae?f=5c224490c513a556c9042463&fbclid=IwAR0EA40-1MS3YNSJRkdnGIjAe6of7e3kIRGVRXq1t14aT44eIx4N6ykJ4L8 |