Alex Simoes alexandersimoes

## installing-clickhouse-locally-osx.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                alexandersimoes
                / installing-clickhouse-locally-osx.md
            
            
              Created
              October 28, 2020 22:21
            
              
                Instructions for installing Clickhouse on OSX
              
          
First install Docker: https://docs.docker.com/docker-for-mac/install/
Create docker instance based on Clickhouse Server image

docker run -d --name oec-clickhouse -p 9000:9000 -ulimit nofile=2662144:2662144 yandex/clickhouse-server

-d = Run container in background and print container ID
-p = Publish a container’s port(s) to the host
-ulimit nofile=xxxx = This sets the number of open files (n = number, o = open, file = files)

  
## tree_map_artists.html
<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Tree Map of Artists D3plus</title>

  <!-- load D3plus CSS -->
  <link href="/css/d3plus.css" media="screen" rel="stylesheet" type="text/css" />

## tree_map_simple.html
<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Tree Map with D3plus</title>

  <!-- load D3plus CSS -->
  <link href="/css/d3plus.css" media="screen" rel="stylesheet" type="text/css" />

## albums.tsv

          
            count
            name
            album_id

            
              1
              Chant Down Babylon: The Island Anthology
              63

            
              1
              The Universal Masters Collection
              84

            
              1
              New Found Glory
              92

            
              1
              Tha Smokin' Nephew
              108

            
              1
              blink-182
              109

            
              1
              Here Without You
              130

            
              1
              Take The Box
              133

            
              1
              Hypocrisy Is The Greatest Luxury
              205

            
              1
              Victims
              213

## artist_network_rings_custom.html
<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Networks with D3plus</title>

  <!-- load D3plus CSS -->
  <link href="/css/d3plus.css" media="screen" rel="stylesheet" type="text/css" />


## artist_network_rings.html
<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Networks with D3plus</title>

  <!-- load D3plus CSS -->
  <link href="/css/d3plus.css" media="screen" rel="stylesheet" type="text/css" />


## format_data.html
<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Networks with D3plus</title>

  <!-- load D3plus CSS -->
  <link href="/css/d3plus.css" media="screen" rel="stylesheet" type="text/css" />


## edges.tsv

          
            source
            target
            strength

            
              AR82DJK1187B991107
              AR8RXRI1187FB4104B
              0.7415193453742193

            
              ARHONG11187FB3B120
              AR12F2S1187FB56EEF
              0.3536419994065859

            
              ARBUOOR1187B997391
              ARH6W4X1187B99274F
              0.7595060502321512

            
              ARJVTRE1187B9959C0
              ARJ9DSA1187B990E00
              0.5657611820969316

            
              ARZKUQF11F4C8456E8
              AR9W3X91187FB3994C
              0.07128961484311336

            
              AREV2491187B9B017E
              ARSQDUN1187B98D7D7
              0.7202580236323695

            
              AREV2491187B9B017E
              AR1ZYLH1187B98C159
              0.2980414346726571

            
              AR0IVSA1187FB4F069
              ARSW5F51187FB4CFC9
              0.4975577971102336

            
              ARDG9Z71187B997023
              ARD3LXU1187B9ABFC5
              0.8064157953492551

## sample_network.html
<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Networks with D3plus</title>

  <!-- load D3plus CSS -->
  <link href="/css/d3plus.css" rel="stylesheet" type="text/css" />


## edges.json
[
   {
      "target": 1,
      "source": 2,
      "strength": 5.234897
   },
   {
      "source": 1,
      "target": 4,
      "strength": 2.34987
	<!doctype html>
	<html>

	<head>
	<meta charset="utf-8">
	<title>Tree Map of Artists D3plus</title>

	<!-- load D3plus CSS -->
	<link href="/css/d3plus.css" media="screen" rel="stylesheet" type="text/css" />
count	name	album_id
1	Chant Down Babylon: The Island Anthology	63
1	The Universal Masters Collection	84
1	New Found Glory	92
1	Tha Smokin' Nephew	108
1	blink-182	109
1	Here Without You	130
1	Take The Box	133
1	Hypocrisy Is The Greatest Luxury	205
1	Victims	213
source	target	strength
AR82DJK1187B991107	AR8RXRI1187FB4104B	0.7415193453742193
ARHONG11187FB3B120	AR12F2S1187FB56EEF	0.3536419994065859
ARBUOOR1187B997391	ARH6W4X1187B99274F	0.7595060502321512
ARJVTRE1187B9959C0	ARJ9DSA1187B990E00	0.5657611820969316
ARZKUQF11F4C8456E8	AR9W3X91187FB3994C	0.07128961484311336
AREV2491187B9B017E	ARSQDUN1187B98D7D7	0.7202580236323695
AREV2491187B9B017E	AR1ZYLH1187B98C159	0.2980414346726571
AR0IVSA1187FB4F069	ARSW5F51187FB4CFC9	0.4975577971102336
ARDG9Z71187B997023	ARD3LXU1187B9ABFC5	0.8064157953492551
	[
	{
	"target": 1,
	"source": 2,
	"strength": 5.234897
	},
	{
	"source": 1,
	"target": 4,
	"strength": 2.34987