gistfile1.txt

memSqlContext.getMemSQLCluster.withMasterConn(conn => {
    conn.withStatement(stmt => {
      stmt.execute(s"CREATE DATABASE IF NOT EXISTS adLogs")
      stmt.execute(s"DROP TABLE IF EXISTS adLogs.adImpressions")
      stmt.execute(
            	“CREATE TABLE adLogs.adImpressions
            	(timestamp bigint,
            	publisher varchar(15),
            	advertiser varchar(15),
            	website varchar(20),
            	geo varchar(4),
            	bid double,
            	cookie varchar(20),
            	KEY (`timestamp`) USING CLUSTERED COLUMNSTORE,
            	SHARD KEY (timestamp))”)
    })
  })