[jira] [Created] (SPARK-20829) var_sampe returns Nan while other vendors return a null value

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created SPARK-20829:
----------------------------------

             Summary: var_sampe 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org