1114#SELECTシンボル表ç¾ã¨$メソッドã¯import sqlContext.implicits._ã‚’è¡Œã„ã€implicit classをインãƒãƒ¼ãƒˆã™ã‚‹ã¨ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ・WHERE WHEREã¯ãƒ‡ãƒ¼ã‚¿ã®ãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚°æ¡ä»¶ã‚’指定ã—ã¾ã™ã€‚ ※ã“ã“らã¸ã‚“ã¯SQL99ç‰ã®ä»•æ§˜ã¨åŒã˜ã§ã™ã€‚ SQL >>> SELECT * FROM dataframe WHERE col2 > 0 DataFrame >>> DataFrameã§ã¯filterを使ã†ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ DataFrame .where( $"col2" > 0 ) DataFrame .filter( $"col2".isNull ) ・JOIN JOINã¯è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿(テーブル)ã‚’æ¡ä»¶ã«å¾“ã£ã¦çµåˆã—ã¾ã™ã€‚ 使ãˆã‚‹JOINタイプã¯ä¸‹è¨˜ã®ã¨ãŠã‚Šã§ã™ã€‚ å˜ã«JOINã¨ã ã‘指定ã™ã‚‹ã¨INNER JOINã¨ãªã‚Šã¾ã™ã€‚ LEFT SEMI JOINã¯
{{#tags}}- {{label}}
{{/tags}}