snaga

snaga

#!/bin/sh

cd `dirname $0`
pwd

PGHOME=/usr/pgsql-9.6
export PGHOME

function git_checkout()
{

snaga

#!/bin/sh

if [ -z "$1" ]; then
    echo "Usage: $0 <python file>"
    exit 0
fi

M=`echo $1 | sed 's/.py//'`

echo $M

snaga

#!/usr/bin/env python2.7
# -*- coding: utf-8 -*-

import codecs
import psycopg2
import re
import sys

sys.stdout = codecs.getwriter('utf8')(sys.stdout)

snaga

#!/usr/bin/env python2.7
# -*- coding: utf-8 -*-

import codecs
import re
import sys
from pykml import parser

sys.stdout = codecs.getwriter('utf8')(sys.stdout)

snaga

collectedYear,facet,keyword,mcode,n_docs,mname
2010,タイトル,防災,2000,20747,青森県
2010,タイトル,防災,15000,17671,新潟県
2010,タイトル,防災,27000,9956,大阪府
2010,タイトル,防災,22130,1845,静岡県 浜松市
2010,タイトル,防災,32000,1752,島根県
2010,タイトル,防災,28000,1599,兵庫県
2010,タイトル,防災,12000,1598,千葉県
2010,タイトル,防災,37000,1516,香川県
2010,タイトル,防災,13000,1119,東京都

snaga

select version();

create table t1 as
select generate_series(1,10000000) c1;

set force_parallel_mode = true;
set max_parallel_workers_per_gather = 4;

create or replace function f1_safe(c int8)
  returns int8

snaga

testdb=# select version();
                                                   version
-------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit
(1 row)

testdb=# create table t1 as
testdb-# select generate_series(1,10000000) c1;
SELECT 10000000
testdb=# set force_parallel_mode = true;

snaga

#!/bin/sh

rm -rf incubator-madlib
git clone https://github.com/snaga/incubator-madlib.git
cd incubator-madlib
git checkout v1.9
git log -1

function _build()
{

snaga

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import re
import sys

out = ""

in_pre = False
in_ul = False