EvgenAnufriev

EvgenAnufriev / dim_calendar.hql

Created May 14, 2018 08:28 — forked from PeterAttardo/dim_calendar.hql

Create calendar dimension table in hive query language (HQL)


	set hivevar:start_date=0000-01-01;
	set hivevar:days=1000000;
	set hivevar:table_name=[INSERT YOUR TABLE NAME HERE];

	-- If you are running a version of HIVE prior to 1.2, comment out all uses of date_format() and uncomment the lines below for equivalent functionality

	CREATE TABLE IF NOT EXISTS ${table_name} AS
	WITH dates AS (
	SELECT date_add("${start_date}", a.pos) as date

EvgenAnufriev / control.sh

Created April 16, 2018 16:20 — forked from randerzander/control.sh

Ambari Service Start/Stop script

	USER='admin'
	PASS='admin'
	CLUSTER='dev'
	HOST=$(hostname -f):8080

	function start(){
	curl -u $USER:$PASS -i -H 'X-Requested-By: ambari' -X PUT -d \
	'{"RequestInfo": {"context" :"Start '"$1"' via REST"}, "Body": {"ServiceInfo": {"state": "STARTED"}}}' \
	http://$HOST/api/v1/clusters/$CLUSTER/services/$1
	}