Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B747D1926E for ; Fri, 8 Apr 2016 11:07:01 +0000 (UTC) Received: (qmail 74407 invoked by uid 500); 8 Apr 2016 11:06:40 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 74252 invoked by uid 500); 8 Apr 2016 11:06:40 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 73765 invoked by uid 99); 8 Apr 2016 11:06:40 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Apr 2016 11:06:40 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id E7F35180361 for ; Fri, 8 Apr 2016 11:06:39 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, 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: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id kYYuViciCpHU for ; Fri, 8 Apr 2016 11:06:38 +0000 (UTC) Received: from mail-oi0-f54.google.com (mail-oi0-f54.google.com [209.85.218.54]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 1A5385F3F4 for ; Fri, 8 Apr 2016 11:06:38 +0000 (UTC) Received: by mail-oi0-f54.google.com with SMTP id w85so132590580oiw.0 for ; Fri, 08 Apr 2016 04:06:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=pS2jzIZA1+/cH80DX2IHF1IArZFsbSY+W3QZtZx6R6U=; b=UpkEl9xQXlLhoBdFXKnC3GD70W/J2oRRNwZWztqM8Wbm2JHF2RqQ4xVq59fMA8zvQv C05JMhZfuyHUSwSYrUUWPojjr6ujGMpjXRvuIFdzIn2lIf8YPxiBp8FRU1mvyP4MpajR ymeyuw8dXh4f75hk1oKj26DKHrMQs+J7MaXR+/RLUBy2tEUqm2y/q/iSJDD3X5oHYTMS JawWLPfWQS5agsO8/QHlEB+I53YNzIx1UiAs4P12gIsgKWNeTa+JEZz5PIGy9H68R2mh 4NwjMOe+tvSkw5tE+msnyX9Dtni37sb9/md/LA+w7LLxTdodd3HJrmVjzHhVwtKayHfp o2VQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=pS2jzIZA1+/cH80DX2IHF1IArZFsbSY+W3QZtZx6R6U=; b=IJoW9FUIKyERNMijDsfARWHM2D3DCZy/6mY92VWwq4mIac2ccpbMHP5mdskpmw+r10 BKkrgfCgmjcWsZBw/2pgH8usXBQpEuBl3lUykfBoH7paELclVPQ/+X6Pz39lsZ3xYhBT dUrwAJoXYTJTuit9iij0802xZ8Qrj8lNZRzKqY5QfpeGDWhwoJTD2eVqzbFnAJ5ZlPUj zpFUGLSEjfHcS+lunKGRfr6iUpAsC65K30Q7ju1R7Tr0ihC2tjP7Pi0m4uAQpJKO2eO2 qjH6EzWho9bovUgPQSg6z6apvssXCf+kyLsAVbc7kKatwn+fKJhlEOxQ0BqET6r3MyV6 i0oA== X-Gm-Message-State: AD7BkJJnj0+tcWceqFdOuz+RnSjKZGFRm09urar0JQRfr06At/SBuKjfPmls/Ou38LxF0lTGJI7IEBiHW2QI8A== MIME-Version: 1.0 X-Received: by 10.157.41.68 with SMTP id d62mr3596929otb.57.1460113596957; Fri, 08 Apr 2016 04:06:36 -0700 (PDT) Received: by 10.202.224.7 with HTTP; Fri, 8 Apr 2016 04:06:36 -0700 (PDT) In-Reply-To: References: Date: Fri, 8 Apr 2016 07:06:36 -0400 Message-ID: Subject: Re: [HELP:]Save Spark Dataframe in Phoenix Table From: Josh Mahonin To: user@phoenix.apache.org Cc: "user @spark" , user@hadoop.apache.org, user@hbase.apache.org Content-Type: multipart/alternative; boundary=94eb2c04f3a4474c3e052ff7303e --94eb2c04f3a4474c3e052ff7303e Content-Type: text/plain; charset=UTF-8 Hi Divya, That's strange. Are you able to post a snippet of your code to look at? And are you sure that you're saving the dataframes as per the docs ( https://phoenix.apache.org/phoenix_spark.html)? Depending on your HDP version, it may or may not actually have phoenix-spark support. Double-check that your Spark configuration is setup with the right worker/driver classpath settings. and that the phoenix JARs contain the necessary phoenix-spark classes (e.g. org.apache.phoenix.spark.PhoenixRelation). If not, I suggest following up with Hortonworks. Josh On Fri, Apr 8, 2016 at 1:22 AM, Divya Gehlot wrote: > Hi, > I hava a Hortonworks Hadoop cluster having below Configurations : > Spark 1.5.2 > HBASE 1.1.x > Phoenix 4.4 > > I am able to connect to Phoenix through JDBC connection and able to read > the Phoenix tables . > But while writing the data back to Phoenix table > I am getting below error : > > org.apache.spark.sql.AnalysisException: > org.apache.phoenix.spark.DefaultSource does not allow user-specified > schemas.; > > Can any body help in resolving the above errors or any other solution of > saving Spark Dataframes to Phoenix. > > Would really appareciate the help. > > Thanks, > Divya > --94eb2c04f3a4474c3e052ff7303e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

On Fri, Apr 8, 2016 at = 1:22 AM, Divya Gehlot <divya.htconex@gmail.com> wrote:=
Hi,
I hava a Horton= works Hadoop cluster having below Configurations :
Spark 1.5.2
HBASE 1.1.x
Phoenix 4.4=C2=A0

I = am able to connect to Phoenix through JDBC connection and able to read the = Phoenix tables .
But while writing the data back to Phoenix table= =C2=A0
I am getting below error :

o= rg.apache.spark.sql.AnalysisException: org.apache.phoenix.spark.DefaultSour= ce does not allow user-specified schemas.;

C= an any body help in resolving the above errors or any other solution of sav= ing Spark Dataframes to Phoenix.

Would really appa= reciate the help.

Thanks,
Divya=C2=A0

--94eb2c04f3a4474c3e052ff7303e--