[ https://issues.apache.org/jira/browse/SPARK-20829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
N Campbell updated SPARK-20829: ------------------------------- Summary: var_samp returns Nan while other vendors return a null value (was: var_sampe returns Nan while other vendors return a null value) > var_samp returns Nan while other vendors return a null value > ------------------------------------------------------------ > > Key: SPARK-20829 > URL: https://issues.apache.org/jira/browse/SPARK-20829 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.1.0 > Reporter: N Campbell > Priority: Minor > > SELECT > sno AS SNO, > pno AS PNO, > VAR_SAMP(qty) AS C1 > FROM > tsupply > GROUP BY > sno, > pno > create table if not exists TSUPPLY (RNUM int , SNO string, PNO string, JNO > string, QTY int ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > STORED AS textfile ; -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org