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 2219B200C3D for ; Tue, 14 Mar 2017 18:01:10 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 20AA9160B7E; Tue, 14 Mar 2017 17:01:10 +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 69347160B63 for ; Tue, 14 Mar 2017 18:01:09 +0100 (CET) Received: (qmail 77454 invoked by uid 500); 14 Mar 2017 17:01:08 -0000 Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@carbondata.incubator.apache.org Delivered-To: mailing list issues@carbondata.incubator.apache.org Received: (qmail 77438 invoked by uid 99); 14 Mar 2017 17:01:06 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Mar 2017 17:01:06 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 54912C022F for ; Tue, 14 Mar 2017 17:01:06 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -4.02 X-Spam-Level: X-Spam-Status: No, score=-4.02 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id WTcDa6uulT9z for ; Tue, 14 Mar 2017 17:01:05 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id 306495F343 for ; Tue, 14 Mar 2017 17:01:04 +0000 (UTC) Received: (qmail 77405 invoked by uid 99); 14 Mar 2017 17:01:03 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Mar 2017 17:01:03 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 509ADDFC15; Tue, 14 Mar 2017 17:01:03 +0000 (UTC) From: jackylk To: issues@carbondata.incubator.apache.org Reply-To: issues@carbondata.incubator.apache.org References: In-Reply-To: Subject: [GitHub] incubator-carbondata pull request #630: [CARBONDATA-730] added decimal type ... Content-Type: text/plain Message-Id: <20170314170103.509ADDFC15@git1-us-west.apache.org> Date: Tue, 14 Mar 2017 17:01:03 +0000 (UTC) archived-at: Tue, 14 Mar 2017 17:01:10 -0000 Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/630#discussion_r105967481 --- Diff: integration/spark/src/test/scala/org/apache/carbondata/integration/spark/testsuite/dataframe/Decimal_DataFrameTest.scala --- @@ -0,0 +1,62 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed with + * this work for additional information regarding copyright ownership. + * The ASF licenses this file to You under the Apache License, Version 2.0 + * (the "License"); you may not use this file except in compliance with + * the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.carbondata.integration.spark.testsuite.dataframe + +import java.math.BigDecimal + +import org.apache.spark.sql.common.util.DataFrameUtils +import org.apache.spark.sql.types.{DecimalType, DoubleType, StringType, StructField, StructType} +import org.apache.spark.sql.{Row, SaveMode} +import org.scalatest.FunSuiteLike + +class Decimal_DataFrameTest extends FunSuiteLike { + + val carbonContext = DataFrameUtils.createCarbonContext("Decimal_DataFrameTest") + + carbonContext.sql("DROP TABLE IF EXISTS carbon3") + + val rdd = carbonContext.sc.parallelize( + Row(52.23, BigDecimal.valueOf(1234.4440), "Warsaw") :: + Row(42.30, BigDecimal.valueOf(9999.9990), "Corte") :: Nil) + + val schema = StructType( + StructField("double", DoubleType, nullable = false) :: + StructField("decimal", DecimalType(9, 2), nullable = false) :: + StructField("string", StringType, nullable = false) :: Nil) + + val dataFrame = carbonContext.createDataFrame(rdd, schema) + + dataFrame.printSchema() + + dataFrame.write + .format("carbondata") + .option("tableName", "carbon3") + .option("compress", "true") + .mode(SaveMode.Overwrite) + .save() + + test("select salary from table") { + val actualDataFrame = carbonContext.sql("SELECT decimal FROM carbon3") + actualDataFrame.show() + val actualResult = actualDataFrame.collect().toList + val expectedResult = List(Row(10000.00) :: Nil, Row(1234.44) :: Nil) + assert((actualResult diff expectedResult).isEmpty) --- End diff -- use `checkAnswer` like in the `TestLoadDataFrame` --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastructure@apache.org or file a JIRA ticket with INFRA. ---