David G. Cueva Tello davidcueva

## com.google.cloud.hadoop2GCP.visualizationSec.570.selectStarTableau.sh
SELECT *
FROM `default`.`transactions`

## com.google.cloud.hadoop2GCP.visualizationSec.560.selectTableau.sh
SELECT `submissiondate`,
       `transactiontype`
FROM `default`.`transactions`

## com.google.cloud.hadoop2GCP.visualizationSec.550.sshTunnel.sh
echo "gcloud compute ssh ${PROXY_CLUSTER}-m \
  --project ${PROJECT_ID} \
  --zone ${ZONE} \
  -- -L 8443:localhost:8443"

## com.google.cloud.hadoop2GCP.visualizationSec.540.getExtIP.sh
gcloud compute instances describe ${PROXY_CLUSTER}-m --zone=${ZONE} \
  --format='get(networkInterfaces[0].accessConfigs[0].natIP)'

## com.google.cloud.hadoop2GCP.visualizationSec.530.addTags.sh
gcloud compute instances add-tags ${PROXY_CLUSTER}-m --zone=${ZONE} \
  --tags=knox-gateway

## com.google.cloud.hadoop2GCP.visualizationSec.520.knoxFirewall.sh
gcloud compute firewall-rules create allow-knox\
  --project=${PROJECT_ID} --direction=INGRESS --priority=1000 \
  --network=default --action=ALLOW --rules=tcp:8443 \
  --target-tags=knox-gateway \
  --source-ranges=<your-public-ip>/32

## com.google.cloud.hadoop2GCP.visualizationSec.510.selectTxCols.sql
SELECT submissionDate, transactionType
  FROM transactions
  LIMIT 10;

## com.google.cloud.hadoop2GCP.visualizationSec.500.selectStarTx.sql
SELECT *
  FROM transactions
  LIMIT 10;

## com.google.cloud.hadoop2GCP.visualizationSec.490.beelineMary.sh
beeline -u "jdbc:hive2://localhost:10000/;transportMode=http;httpPath=cliservice mary user-password"

## com.google.cloud.hadoop2GCP.visualizationSec.480.restartHive.sh
sudo service hive-server2 restart
	SELECT `submissiondate`,
	`transactiontype`
	FROM `default`.`transactions`
	echo "gcloud compute ssh ${PROXY_CLUSTER}-m \
	--project ${PROJECT_ID} \
	--zone ${ZONE} \
	-- -L 8443:localhost:8443"
	gcloud compute instances describe ${PROXY_CLUSTER}-m --zone=${ZONE} \
	--format='get(networkInterfaces[0].accessConfigs[0].natIP)'
	gcloud compute instances add-tags ${PROXY_CLUSTER}-m --zone=${ZONE} \
	--tags=knox-gateway
	gcloud compute firewall-rules create allow-knox\
	--project=${PROJECT_ID} --direction=INGRESS --priority=1000 \
	--network=default --action=ALLOW --rules=tcp:8443 \
	--target-tags=knox-gateway \
	--source-ranges=<your-public-ip>/32
	SELECT submissionDate, transactionType
	FROM transactions
	LIMIT 10;