stevehenderson

kubectl get pods --namespace somens -o wide | awk '{print $7,"   ", $1}' | sort

stevehenderson

So I'm playing around with Harmony @ cs.cornell.edu.

Install steps (Ubuntu 20) [Should work on WSL]

Install Prequisites

You need to have build-essential, clang, python3 + dev headers, and graphviz

I also always install anything python related in its own virtual environments, so I added the python3-venv package

stevehenderson

Sometimes you delete stuff on GKE Autopilot and it doesn't take:

kubectl delete pv troubledvolume --grace-period=0 --force
kubectl patch pv troubledvolume -p '{"metadata": {"finalizers": null}}'

stevehenderson

# The following sets the over all timeout
timeout: 7200s
- name: 'gcr.io/cloud-builders/gsutil'
  args: ['cp', 'gs://project-volumes/big-project/big-file.tar', '.']
  waitFor: ['-']  # The '-' indicates that this step begins immediately.
  timeout: 4600s  # Per step timeout

stevehenderson

- id: "Read Values"
  name: ubuntu
  entrypoint: bash
  args:
    - -c
    - |
      # Read from "/workspace"
      echo "Where am I " $(pwd)
      echo "Contents " $(ls)  

stevehenderson

curl ipinfo.io/ip
curl api.ipify.org
curl checkip.dyndns.org
dig +short myip.opendns.com @resolver1.opendns.com
host myip.opendns.com resolver1.opendns.com
curl ident.me
curl bot.whatismyipaddress.com
curl ipecho.net/plain
curl ifconfig.me
curl -4/-6 icanhazip.com

stevehenderson

# First run this in top cell:  pip install pyhive
from pandas import read_sql
from pyhive import presto

presto_conn = presto.Connection(host="collab-cluster-hostname-m", schema="your_presto_schema", catalog="presto_catalog", port=8060, username ="presto")
presto_cursor = presto_conn.cursor()

# Query presto node
query = "select * FROM system.runtime.nodes"
query_result = read_sql(query, presto_conn) 

stevehenderson

diff --git a/pg_graphql--0.3.3.sql b/pg_graphql--0.3.3.sql
index 1c7e735..c35ca13 100644
--- a/pg_graphql--0.3.3.sql
+++ b/pg_graphql--0.3.3.sql
@@ -3226,19 +3226,19 @@ begin
             order by
                 %s
             limit
-                least(%s, 30) + 1
+                least(%s, 150) + 1

stevehenderson

-- You will need to remove some quotation marks
select 'drop table if exists "schema_name"."' || tablename || '" cascade;' 
  from pg_tables
 where schemaname = 'schema_name';

stevehenderson

WITH RECURSIVE pg_inherit(inhrelid, inhparent) AS
    (select inhrelid, inhparent
    FROM pg_inherits
    UNION
    SELECT child.inhrelid, parent.inhparent
    FROM pg_inherit child, pg_inherits parent
    WHERE child.inhparent = parent.inhrelid),
pg_inherit_short AS (SELECT * FROM pg_inherit WHERE inhparent NOT IN (SELECT inhrelid FROM pg_inherit))
SELECT table_schema
    , TABLE_NAME