spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SPARK-20829) var_samp returns Nan while other vendors return a null value
Date Sun, 21 May 2017 16:05:04 GMT

     [ https://issues.apache.org/jira/browse/SPARK-20829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

N Campbell updated SPARK-20829:
-------------------------------
    Attachment: TSUPPLY

> 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
>         Attachments: TSUPPLY
>
>
> 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


Mime
View raw message