[B! Redshift] opparaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

oppara id:oppara

Redshiftã«é–¢ã™ã‚‹opparaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

S3ã‹ã‚‰RedShiftã¸ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚’ã‚„ã£ã¦ã¿ãŸ | DevelopersIO
1æ™‚é–“ç¨‹åº¦ã§Redshiftã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ãŒã§ãã¾ã™ã€‚Redshiftåˆå¿ƒè€…ã«ãŠã™ã™ã‚ãªã®ã§ã“ã‚Œã‹ã‚‰å‹‰å¼·ã—ãŸã„äººã¯æ˜¯éžã‚„ã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã“ã‚“ã«ã¡ã¯ã€éˆ´æœ¨(ç´”)ã§ã™ã€‚ Redshiftå‹‰å¼·ã—ã¦ã„ã¦ã¡ã‚‡ã†ã©ã‚ˆãS3ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ãŒã‚ã£ãŸã®ã§ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ ã¯ã˜ã‚ã« ä»Šå›žã‚„ã‚‹ã®ã¯ã“ã¡ã‚‰ã®ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã§ã™ã€‚ Redshiftã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã‚’èµ·å‹•ã—ã¦ã€ã‚µãƒ³ãƒ—ãƒ«ã®S3ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã€‚èµ·å‹•ã—ãŸRedshiftã‹ã‚‰ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹ã¨ã“ã‚ã¾ã§ã‚’ã“ã®ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã§ã¯ä½“é¨“ã§ãã¾ã™ã€‚ ã‚„ã£ã¦ã¿ãŸ ãã‚Œã§ã¯ã•ã£ããã‚„ã£ã¦ã„ãã¾ã™ã€‚ 1. IAMãƒãƒ¼ãƒ«ã‚’ä½œæˆã™ã‚‹ ã¾ãšã¯å‰æº–å‚™ã¨ã—ã¦ã€RedShiftã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã¸S3ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’è¨±å¯ã™ã‚‹ãƒãƒ¼ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ AWSã‚µãƒ¼ãƒ“ã‚¹ã®ä¸ã‹ã‚‰Redshiftã‚’é¸æŠžã—ã¾ã™ã€‚ ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨ã€è‡ªå‹•ã§ã‚¹ã‚¯ãƒãƒ¼ãƒ«ã•ã‚Œã¦ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼
oppara 2021/01/06
aws

s3

redshift
ãƒªãƒ³ã‚¯
[Redshift] ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç¸¦æŒã¡ã¨æ¨ªæŒã¡ã‚’å…¥ã‚Œæ›ãˆã‚‹æ–¹æ³• | DevelopersIO
ã¯ã˜ã‚ã« æ—¢ã«å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ç¸¦æŒã¡ã¨æ¨ªæŒã¡ã‚’å…¥ã‚Œæ›¿ãˆã¦è¦‹ãŸã„å ´åˆã®æ–¹æ³•ã‚’æ›¸ã„ã¦ã„ãã¾ã™ã€‚ ç’°å¢ƒ Mac OSX 10.10.5 Yosem ite Redshift 1.0.1125 ç¸¦æŒã¡ â‡¨ æ¨ªæŒã¡ Pivotï¼ˆãƒ”ãƒœãƒƒãƒˆï¼‰ã¨è¨€ã„ã¾ã™ã€‚ ç¸¦æŒã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã®æº–å‚™ å•†å“åˆ¥ã®æœˆåˆ¥å£²ä¸Šã®è¡¨ã§ã™ã€‚ CREATE SCHEMA IF NOT EXISTS blog; CREATE TABLE blog.vertical ( id INTEGER , it em_name VARCHAR(1) , month SMALLINT , amount INTEGER ); INSERT INTO blog.vertical VALUES (1,'A',1,150) ,(2,'A',2,120) ,(3,'A',3,100) ,(4,'B',1,20) ,(5,'B',2,60) ,(6,'B',3,80) ,(
oppara 2017/01/13
Redshift
ãƒªãƒ³ã‚¯
[Redshift] é–¢æ•°ã‚’ä½¿ç”¨ã—ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ã‹ã‚‰æ¬¡ã®èª•ç”Ÿæ—¥ã‚’å‰²ã‚Šå‡ºã—ã¦ã‚«ã‚¦ãƒ³ãƒˆãƒ€ã‚¦ãƒ³ã™ã‚‹ | DevelopersIO
ã¯ã˜ã‚ã« ç™»éŒ²ã•ã‚ŒãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ç”Ÿå¹´æœˆæ—¥ã‹ã‚‰èª•ç”Ÿæ—¥ã¾ã§ã®ã‚«ã‚¦ãƒ³ãƒˆãƒ€ã‚¦ãƒ³ã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³•ã‚’æ›¸ãã¾ã™ã€‚ ç’°å¢ƒ MacOSX 10.10.5 Yosem ite Redshift 1.0.1125 æº–å‚™ ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ãƒ†ãƒ¼ãƒ–ãƒ«ï¼šuser_profile CREATE TABLE IF EXISTS blog; CREATE TABLE blog.user_profile ( user_id INTEGER , user_name VARCHAR(50) , birth DATE , sex SMALLINT , PRIMARY KEY(user_id) ); INSERT INTO blog.user_profile VALUES (1001,'Abiel','1980-01-01',0) ,(1002,'Salome','1990-03-05',0) ,(1003,'Cornelius','2000-
oppara 2017/01/13
Redshift
ãƒªãƒ³ã‚¯
[Redshift] é–¢æ•°ã‚’ä½¿ç”¨ã—ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ã®ç”Ÿå¹´æœˆæ—¥ã‹ã‚‰ç¾åœ¨ã®å¹´é½¢ã€æ›œæ—¥ã‚’è¡¨ç¤ºã™ã‚‹ | DevelopersIO
ã¯ã˜ã‚ã« ç™»éŒ²ã•ã‚ŒãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ç”Ÿå¹´æœˆæ—¥ã‹ã‚‰å¹´é½¢ã¨æ›œæ—¥ã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã€Redshiftã§ã©ã†ã™ã‚Œã°è‰¯ã„ã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ç’°å¢ƒ MacOSX 10.10.5 Yosem ite Redshift 1.0.1125 æº–å‚™ ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ãƒ†ãƒ¼ãƒ–ãƒ«ï¼šuser_profile CREATE TABLE IF EXISTS blog; CREATE TABLE blog.user_profile ( user_id INTEGER , user_name VARCHAR(50) , birth DATE , sex SMALLINT , PRIMARY KEY(user_id) ); INSERT INTO blog.user_profile VALUES (1001,'Abiel','1980-01-01',0) ,(1002,'Salome','1990-03-05',0) ,(1003,'Co
oppara 2016/12/15
Redshift
ãƒªãƒ³ã‚¯
[Redshift] ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ï¼šNTILEã§ãƒ‡ã‚·ãƒ«åˆ†æžã‚’è¡Œã„å•†å“åˆ¥ã®è²©å£²æ¯”çŽ‡ã‚’è¡¨ç¤ºã™ã‚‹ | DevelopersIO
ã¯ã˜ã‚ã« åˆ†æžã«ã¤ã„ã¦å¦ç¿’ã—ã¦ã„ã¦ãƒ‡ã‚·ãƒ«åˆ†æžã«å‡ºä¼šã„ã¾ã—ãŸã€‚ã¨ã¦ã‚‚æœ‰ç”¨ã«æ„Ÿã˜ãŸã®ã§å¦ç¿’çµæžœã‚’è¨˜ã—ã¦ãŠãã¾ã™ã€‚ ç’°å¢ƒ Mac OSX 10.10.5 Redshift 1.0.1125 ãƒ‡ã‚·ãƒ«åˆ†æžã¨ã¯ å¯¾è±¡ãƒ‡ãƒ¼ã‚¿ã‚’10ç‰åˆ†ï¼ˆãƒ©ãƒ†ãƒ³èªžã§ãƒ‡ã‚·ãƒ«ï¼‰ã«ã—ã¦å£²ä¸Šã®å‰²åˆãªã©ã‚’åˆ†æžã™ã‚‹æ‰‹æ³•ã®æ§˜ã§ã™ã€‚ æº–å‚™ CREATE SCHEMA IF NOT EXISTS blog; DROP TABLE IF EXISTS blog.pre_decil; CREATE TABLE blog.pre_decil ( id integer , user_id integer , it em_id integer , sales_date date , price integer , quantity integer ); INSERT INTO blog.pre_decil VALUES ( 1,333, 3,'2016
oppara 2016/12/11
Redshift
ãƒªãƒ³ã‚¯
[Redshift] ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°ï¼šROW_NUMBERã‚’ä½¿ç”¨ã—ã¦ã‚°ãƒ«ãƒ¼ãƒ—ã”ã¨ã®æœ€æ–°æ—¥ã®ã¿ã‚’æŠ½å‡ºã™ã‚‹ | DevelopersIO
ã¯ã˜ã‚ã« ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹éš›ã«ã€å‚ç…§ã—ãŸã„åˆ¥ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®çŠ¶æ…‹ãŒç†æƒ³çš„ãªå½¢ã«ãªã£ã¦ã„ãªã„å ´åˆã€ãã®ã¾ã¾ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã§ããªã„äº‹ãŒã‚ã‚Šã¾ã™ã€‚ãã“ã§ã€ã‚ã‚‹çŠ¶æ³ä¸‹ã§ã©ã†ã—ãŸã‚‰ç†æƒ³çš„ãªå½¢ã«ã™ã‚‹ã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ç’°å¢ƒ MacOSX 10.10.5 Yosem ite Redshift 1.0.1125 ãƒ†ãƒ¼ãƒ–ãƒ«ã®æº–å‚™ å•†å“ã®è²©å£²æ—¥ãƒªã‚¹ãƒˆï¼šit em_sale_update CREATE SCHEMA IF EXISTS blog; DROP TABLE IF EXISTS blog.it em_sale_update; CREATE TABLE blog.it em_sale_update ( id INTEGER , it em_name VARCHAR(8) , group_id INTEGER , on_off INTEGER , update_date DATE ); INSERT INTO bl
oppara 2016/12/11
Redshift
ãƒªãƒ³ã‚¯
[Redshift] STL_INSERTã¨STL_QUERYã‚’ä½¿ç”¨ã—ã¦éŽåŽ»ã«å®Ÿè¡Œã—ãŸã‚¯ã‚¨ãƒªã®æƒ…å ±ã‚’èª¿ã¹ã‚‹ | DevelopersIO
ã¯ã˜ã‚ã« SQLã®ä½œæˆã‚„ä¿®æ£ã™ã‚‹éš›ã«ã€éŽåŽ»ã®ã‚¯ã‚¨ãƒªã®å®Ÿè¡ŒçŠ¶æ³ã‚’ç¢ºèªã—ãŸã„äº‹ãŒæœ‰ã‚Šã¾ã™ã€‚Redshiftã§ã¯ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã‚’èµ·å‹•ã—ã¦ã‹ã‚‰çµ‚äº†ã™ã‚‹ã¾ã§ã®ã‚¯ã‚¨ãƒªã‚’ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰è¦‹ã‚‹äº‹ãŒã§ãã¾ã™ãŒã€ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã«ä¿å˜ãŒã§ããªã‹ã£ãŸã‚Šã€ä¿å˜æœŸé–“ãŒçŸã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ Redshiftã«ã¯å®Ÿè¡Œã—ãŸã‚¯ã‚¨ãƒªã‚’è‡ªå‹•çš„ã«ä¿å˜ã—ã¦ãã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãŒæœ‰ã‚‹ã®ã§æ´»ç”¨ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç’°å¢ƒ MacOSX 10.10.5 Yosem ite Redshift 1.0.1125 ä½¿ç”¨ã™ã‚‹STLãƒ†ãƒ¼ãƒ–ãƒ« STL_INSERT Amazon Redshift | STL_INSERT åˆ—å ãƒ‡ãƒ¼ã‚¿åž‹ èª¬æ˜Ž userid
oppara 2016/12/04
Redshift
ãƒªãƒ³ã‚¯
[Redshift][PostgreSQL] WITHå¥ã‚’ä½¿ã£ã¦SQLã‚’ã‚·ãƒ³ãƒ—ãƒ«ã«ã€‚ | DevelopersIO
ç’°å¢ƒ MAC OSX 10.10.5 Yosem ite ä½¿ã„æ–¹ï¼ˆä¾‹ï¼‰ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æº–å‚™ CREATE TABLE it ems ( id SMALLINT , name VARCHAR(16) , it em_id SMALLINT , it em_name VARCHAR(16) , PRIMARY KEY(id, it em_id) ); INSERT INTO it ems VALUES (1, 'æ–‡æˆ¿å…·', 1, 'ã‚·ãƒ£ãƒ¼ãƒšãƒ³') , (1, 'æ–‡æˆ¿å…·', 2, 'æ¶ˆã—ã‚´ãƒ ') , (1, 'æ–‡æˆ¿å…·', 3, 'å®šè¦') , (2, 'ã‹ã°ã‚“', 1, 'ãƒªãƒ¥ãƒƒã‚¯ã‚µãƒƒã‚¯') , (2, 'ã‹ã°ã‚“', 2, 'ã‚·ãƒ§ãƒ«ãƒ€ãƒ¼ãƒãƒƒã‚°'); CREATE TABLE genre ( id SMALLINT , name VARCHAR(16) ,PRIMARY KEY(id) ); # SELECT *
oppara 2016/11/10
Redshift

PostgreSQL
ãƒªãƒ³ã‚¯
[Redshift] psqlã®ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã‚’å›žé¿ã™ã‚‹ | Developers.IO
ã“ã‚“ã«ã¡ã¯ã€DIéƒ¨ã®å·å´Žã§ã™ã€‚ Redshiftã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨ã—ã¦Macä¸Šã®psqlã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ãŒã€å‡¦ç†ã«é•·æ™‚é–“ã‹ã‹ã‚‹ã‚¯ã‚¨ãƒªã®å ´åˆã€ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆãŒç™ºç”Ÿã—ã¦ã—ã¾ã„ã€ã‚¯ã‚¨ãƒªã®çµæžœãŒãã¡ã‚“ã¨å–å¾—ã§ããªã„ã€ã¨ã„ã†å•é¡ŒãŒç™ºç”Ÿã—ã¦ã„ã¾ã—ãŸã€‚ ç¤¾å†…ã§è³ªå•ã‚’ã—ãŸã¨ã“ã‚ã€ä¸‹è¨˜ã®ãƒšãƒ¼ã‚¸ã®keepaliveã®è¨å®šã‚’æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã®ã§ã€è©¦ã—ã¦ã¿ã¾ã™ã€‚ï¼ˆæœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯Macã®å ´åˆã‚’è©¦ã—ã¦ã„ã¾ã™ï¼‰ Amazon EC2 ä»¥å¤–ã‹ã‚‰æŽ¥ç¶šã™ã‚‹ â€” ãƒ•ã‚¡ã‚¤ã‚¢ã‚¦ã‚©ãƒ¼ãƒ«ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã®å•é¡Œ http://docs.aws.amazon.com/ja_jp/redshift/latest/mgmt/connecting-firewall-guidance.html sudo sysctl net.inet.tcp.keepintvl=20000 sudo sysctl net.inet.tcp.keepidle=20000
oppara 2016/06/27
Redshift
ãƒªãƒ³ã‚¯
1