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: [email protected]
For additional commands, e-mail: [email protected]
