ã¿ã°æ¤ç´¢ã®è©²å½çµæãå°ãªããããã¿ã¤ãã«æ¤ç´¢çµæã表示ãã¦ãã¾ãã
æ¬ã»ãã·ã§ã³ã§ã¯ã¤ãã³ã管çãµã¼ãã¹ãä¾ã«ã¨ããã»ãã·ã§ã³æ å ±ã®CSVãã¡ã¤ã«ã¨ãã±ããæ å ±ã®CSVãã¡ã¤ã«ããã²ã¨ã¤ã®ãã¡ã¤ã«ã«å¤æããETLãèãã¦ããã¾ããAWS Glue 㨠Amazon Athena ã®ãã¨ãç¥ãããµã¼ãã¼ã¬ã¹ã¢ããªã±ã¼ã·ã§ã³ã«çµã¿è¾¼ãã¤ã¡ã¼ã¸ãæã£ã¦å¸°ã£ã¦ããããã¨ãç®çã§â¦
ã¯ããã« å®é¨ãã¼ã¿çå¤ããã°ã©ããä½æããããç»åã並ã¹ã¦ãã¯ã¼ãã¤ã³ãã«è²¼ãä»ããããªã©ãç 究ãæ¥åã«ããã¦ç¹å®ã®ãã¡ã¤ã«ã«å¯¾ããå®åä½æ¥ãèªååããã¦ããæ¹ã¯å°ãªããªãã¨æãã¾ãã ããã§å®è¡ãã©ã«ããé½åº¦ç°ãªãå ´åãã¹ã¯ãªããå®è¡æã«ãã¹ãæå®ãããããããã¯ã¹ã¯ãªããæ¬ä½ãã¹ã¯ãªããã¸ã®ãªã³ã¯ãã³ãã¼ãã¦å®è¡ãããã¨ã«ãªããã¨æããã¾ãã ããã°ã©ãã§ããã°CUIã§ã®ãã¹æå®ãåããã¨ã¯ç¡ããã¨æããã¾ãããéããã°ã©ãã®ååã«Pythonã¹ã¯ãªãããå©ç¨ãã¦ããã ãã«ãããããªãã¹ã簡便ã«ã¹ã¯ãªãããå®è¡ã§ããããã«è©¦è¡é¯èª¤ãã¾ããã®ã§åå¿é²ã¨ãã¦è¨è¼ãã¦ããã¾ãã çµè«ã¨ãã¾ãã¦ã¯ã"Pythonã¹ã¯ãªãããã¹ãæ¸ãããPowerShellã¹ã¯ãªãã"ããã³"å½PowerShellã¹ã¯ãªãããPowerShellã§å®æ½ãããªã³ã¯"ãSendToãã©ã«ãã«ç½®ããã¨ããææ³ã«è³ã
ã¯ããã« ååã¯ã¨ããããMPEG-2 TSãã1ã¤ã®TSãã±ãããåãåºããããã1è¡ã§ãã³ããã¦ã¿ã¾ãããTSãã±ããã解æããå ´åã次ã«TSãããã解æãã¾ããTSãã±ããã¯å¤§ããåããã¨TSãããã¨ãã¤ãã¼ãã®2ã¤ã§æ§æããã¦ãã¾ãã ä¸å³ã®ãheaderãã¨ãpayloadãã該å½ãã¾ãã ISO/IEC 13818-1 ããå¼ç¨ ãTransport Stream syntax diagramã TSãããã¯é常4ãã¤ãã«ãªããæ®ãããã¤ãã¼ãã¨ãªãã¾ãããã ããadaptation fieldãããå ´åã4ãã¤ãï¼adaptation fieldé·ã¨ãªãã¾ãã TSãããã«ã¤ã㦠TSãããã«è¨è¿°ããã¦ãããã¼ã¿ã«ã¤ãã¦ã¯å ã»ã©ã®å³ã«ããããã«sync byteããadaptation fieldã¨ãªãã¾ãã ç§ãTSãã±ããã解æããéã¯sync byte(0x47)ãå§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã