2018-07-01ã‹ã‚‰1ãƒ¶æœˆé–“ã®è¨˜äº‹ä¸€è¦§

2018-07-15

BigQueryã§æ•´æ•°(INT64åž‹)ã‚„æµ®å‹•å°æ•°ç‚¹æ•°(FLOAT64åž‹)ã‚’ãƒã‚¤ãƒˆåˆ—(BYTESåž‹)ã«ã‚ãƒ£ã‚¹ãƒˆã™ã‚‹

BigQuery

æ•´æ•°(INT64åž‹)ã‚„æµ®å‹•å°æ•°ç‚¹æ•°(FLOAT64åž‹)ã‚’BYTESåž‹ã«ã—ãŸã‹ã£ãŸã®ã§è‡ªå‰ã§å‡¦ç†ã‚’UDFã¨ã—ã¦æ›¸ãã¾ã—ãŸ BigQueryã®CASTé–¢æ•°ã§BYTESåž‹ã«ã‚ãƒ£ã‚¹ãƒˆã§ã§ãã‚‹ã®ã¯BYTESåž‹è‡ªèº«ã¨STRINGåž‹ã«é™ã‚‰ã‚Œã¦ã„ã‚‹ã®ã§ã€ä»–ã®åž‹ã‚’å¤‰æ›ã—ãŸã„ã¨ãã«ã¯è‡ªåˆ†ã§å‡¦ç†ã‚’æ›¸ãå¿…è¦ãŒã‚ã‚Šã¾â€¦

2018-07-01

BigQuery ã§ _TABLE_SUFFIX ã‚’ãƒ“ãƒ¥ãƒ¼ã‚„WITHå¥ã®å¤–å´ã‹ã‚‰æŒ‡å®šã™ã‚‹

BigQuery

BigQueryã®ã‚¯ã‚¨ãƒªã§ãƒ†ãƒ¼ãƒ–ãƒ«åã®æœ«å°¾ã«æ—¥ä»˜ãªã©ã‚’å…¥ã‚Œã¦ãŠã„ã¦ _TABLE_SUFFIX ã®ã‚«ãƒ©ãƒ ã®æ¡ä»¶ã§åˆ©ç”¨ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµžã‚Šè¾¼ã¿ãŸã„æ™‚ã«ã€_TABLE_SUFFIXã®æ¡ä»¶ã‚’ãƒ“ãƒ¥ãƒ¼ã‚„WITHå¥ã®å¤–å´ã‹ã‚‰æ›¸ã„ã¦ã¿ã‚‹è©±ã§ã™