Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id E99B5200B41 for ; Thu, 7 Jul 2016 10:23:43 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id E8333160A68; Thu, 7 Jul 2016 08:23:43 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 389A1160A59 for ; Thu, 7 Jul 2016 10:23:43 +0200 (CEST) Received: (qmail 83753 invoked by uid 500); 7 Jul 2016 08:23:41 -0000 Mailing-List: contact user-help@spark.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list user@spark.apache.org Received: (qmail 83743 invoked by uid 99); 7 Jul 2016 08:23:41 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jul 2016 08:23:41 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id E0BA1C1CBE for ; Thu, 7 Jul 2016 08:23:40 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.821 X-Spam-Level: X-Spam-Status: No, score=-0.821 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id w2bezRhpGtZQ for ; Thu, 7 Jul 2016 08:23:40 +0000 (UTC) Received: from mail-oi0-f46.google.com (mail-oi0-f46.google.com [209.85.218.46]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 9A6D15F1B3 for ; Thu, 7 Jul 2016 08:23:39 +0000 (UTC) Received: by mail-oi0-f46.google.com with SMTP id u201so14042056oie.0 for ; Thu, 07 Jul 2016 01:23:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to; bh=BCWzhDHbqBZPhUbhZl6x3UcVBxHCIuRvpglsF6Gwc9s=; b=C6Of4M2ummj+zXCv/Sx4/qIOQ7wRZwPaq27tEwg7f6QAPYsQBQhMsT3t63bhh/TXE6 O22qCR32vtE7L3rPmUWeSBAOGumlpShFdmNRSkL6gkqxSsx6AatkNZ+ilMuxa/nY5tS3 NyDlO+Dg+IlJm3Tv6aOT8fPpw2wccU/K0VJ9lkjCJjXbvCVsyjB5CKWJKyysU4CoNAee 1fjqVUR/Ce8W8/GmzF+GtvpBkr67jl48ZBwe6p8UZMjtw+wPKDvHu8IXljq95KdaUGB2 4A/nmO/iHYRI9vbG024i9fYhs/n+qWpWOzx+LUSUoes1TYC+flyBL5+jxNCd86ARXzKX uJyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=BCWzhDHbqBZPhUbhZl6x3UcVBxHCIuRvpglsF6Gwc9s=; b=JmldeRkRA8HslbHCvQPJJJxJx+ke1RrBIO2dg14sEMrmbfE8w99hvjaElUCn45C9ev ov/N7q7G/eyzEh8UbX0ZS4xbSsBCGJyyC1+eNBbGFZbSy1/2YXJ1X0a9JGwIhCjG6J2c EUuHALBHsugZOyQwoiTlE9TE0ouNqKmTH6TlFn5u+cFTMXQt2n7OmcwVsBlibad5PW2T pm8w7kpvlE6qMESqrHHYTRZ48vqwlq+RrzcOPToSYkA3v1nVK0QkyPrwa6dusl0Qhgy0 kxNGJa+O2WhMWkee07G32jEPUbv/KLn583RTnym3YGEyUYPA8mHMdYgkvJvalcHxN+er XXSA== X-Gm-Message-State: ALyK8tKepYt5clf8scZFgFxZtHen8Jggsc210lgXsj+HKQbRheaNxILsaj4aoiEbB4O+0KrWM/GXaXkm8NpsBQ== X-Received: by 10.157.60.176 with SMTP id z45mr2908963otc.45.1467879818351; Thu, 07 Jul 2016 01:23:38 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.104.195 with HTTP; Thu, 7 Jul 2016 01:23:37 -0700 (PDT) From: Mungeol Heo Date: Thu, 7 Jul 2016 17:23:37 +0900 Message-ID: Subject: stddev_samp() gives NaN To: user@spark.apache.org Content-Type: text/plain; charset=UTF-8 archived-at: Thu, 07 Jul 2016 08:23:44 -0000 Hello, As I mentioned at the title, stddev_samp function gives a NaN while stddev_pop gives a numeric value on the same data. The stddev_samp function will give a numeric value, if I cast it to decimal. E.g. cast(stddev_samp(column_name) as decimal(16,3)) Is it a bug? Thanks - mungeol --------------------------------------------------------------------- To unsubscribe e-mail: user-unsubscribe@spark.apache.org