arvindshmicrosoft

drop table if exists n;
go

-- create a NODE table containing the various "dots"
CREATE TABLE n (
id INT,
x INT,
y INT
) AS NODE;
INSERT n (id, x, y)

arvindshmicrosoft

IF EXISTS(SELECT * FROM sys.server_event_sessions WHERE name='TraceMemObj')
    DROP EVENT SESSION [TraceMemObj] ON SERVER
GO

CREATE EVENT SESSION [TraceMemObj] ON SERVER 
ADD EVENT sqlos.page_allocated(
    ACTION(package0.callstack)
	WHERE (memory_clerk_name = 'MEMORYCLERK_SOSNODE')
	),
ADD EVENT sqlos.page_freed(

arvindshmicrosoft

declare -x JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk
declare -x PATH=${JAVA_HOME}/bin:${PATH} 
declare -x M2_HOME=/home/mcadmin/install/apache-maven-3.2.5
declare -x MAVEN_HOME=/home/mcadmin/install/apache-maven-3.2.5 
declare -x PATH=${M2_HOME}/bin:${PATH} 
declare -x HADOOP_HOME=/home/mcadmin/install/hadoop-3.1.1
declare -x PATH=${HADOOP_HOME}/bin:${PATH}
declare -x ZOOKEEPER_HOME=/home/mcadmin/install/zookeeper-3.4.14
declare -x PATH=${ZOOKEEPER_HOME}/bin:${PATH}
declare -x ACCUMULO_HOME=/home/mcadmin/install/accumulo-2.0.0-alpha-2

arvindshmicrosoft

CREATE DATABASE [MillionSongDataset]
GO

ALTER DATABASE [MillionSongDataset] SET RECOVERY SIMPLE
GO

USE [MillionSongDataset]
GO

CREATE TABLE [dbo].[train_triplets](