manojkarthick

####################################################################
# Create compute environment and job queue for AWS Batch with Boto3
# Daisuke Miyamoto
# 20200330
#

import boto3
import botocore.waiter
from botocore.exceptions import WaiterError
import time

manojkarthick

!tables - list all tables
!describe {table name} - detailed description of the table

DROP TABLE IF EXISTS my_table; - drops the table named my_table
SELECT * FROM my_table LIMIT 1000; - selects all columns from my_table limiting the result set to 1000 records
DELETE FROM my_table WHERE ID= 321; - deletes a record from my_table where the primary Id is equal to 321
CREATE INDEX idx_last_updated_date ON sales.opportunity(last_updated_date DESC) - Creates a secondary index on a table or view.  The index is kept in sync with the table as data changes.  At query time, the optimizer will use the index if it contains all columns referenced in the query to produce an efficient execution plan.

!quit - quites SQLLine client

manojkarthick

Useful Links / Sources

PrestoDB Selects Doc

Housekeeping

change column type

ALTER TABLE logs.trades CHANGE recentprice price int;

manojkarthick

/*
 PoC WhatsApp enumeration of phonenumbers, profile pics, about texts and online statuses
 Floated div edition
 01-05-2017
 (c) 2017 - Loran Kloeze - loran@ralon.nl
 
 This script creates a UI on top of the WhatsApp Web interface. It enumerates certain kinds
 of information from a range of phonenumbers. It doesn't matter if these numbers are part
 of your contact list. At the end a table is displayed containing phonenumbers, profile pics, 
 about texts and online statuses. The online statuses are being updated every