From user-return-55401-apmail-spark-user-archive=spark.apache.org@spark.apache.org Wed Apr 20 06:34:02 2016 Return-Path: X-Original-To: apmail-spark-user-archive@minotaur.apache.org Delivered-To: apmail-spark-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 802901885B for ; Wed, 20 Apr 2016 06:34:02 +0000 (UTC) Received: (qmail 80518 invoked by uid 500); 20 Apr 2016 06:33:58 -0000 Delivered-To: apmail-spark-user-archive@spark.apache.org Received: (qmail 80394 invoked by uid 500); 20 Apr 2016 06:33:58 -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 80384 invoked by uid 99); 20 Apr 2016 06:33:58 -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; Wed, 20 Apr 2016 06:33:58 +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 27515C29EE for ; Wed, 20 Apr 2016 06:33:58 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-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: spamd1-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 (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id dQgsaVuR7BIl for ; Wed, 20 Apr 2016 06:33:56 +0000 (UTC) Received: from mail-vk0-f45.google.com (mail-vk0-f45.google.com [209.85.213.45]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 3A3525F574 for ; Wed, 20 Apr 2016 06:33:55 +0000 (UTC) Received: by mail-vk0-f45.google.com with SMTP id n67so41642048vkf.3 for ; Tue, 19 Apr 2016 23:33:55 -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=ujIlmZskwYneDLj8tnmE3eGKoWEi64g7ck/HvYvNTBU=; b=kCJxouZTPpfVZqMUrO0299p5ZOVVEnzWuC8Ej3ZEcwYysYfGZ1VynQkyFxLY1sOYl1 hTjDR4y24s3kCu+ckrAqq6svj2H69zEOeJsmGaxZzE1keYOZUijm1mHeRLOrKeF+raC8 FpLeGdVhE6PtohvRvoztLpMsznACuzuNhfx60NfGBWK+guvV4HzTXG1WBF6ccpTgnZhf JRTGYza6x/p4PCwqzCw8OnhvJoRUSZ15dkF9Nc4gVPZHI8JsD8mVhEtltmGnUifyJmND +Lda7qbeCXjPc9WTro8pYOADEA6/6uHstr3CGcjajgWy2gjLplCfCHzL/SlWAF0dnVqw A7Pw== 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=ujIlmZskwYneDLj8tnmE3eGKoWEi64g7ck/HvYvNTBU=; b=iWGtgGPNApzHozxbtekRTQZLJeySXY5Uq7mSgC4w/Pz4vI1BHdGM616UzSYb/J6Z3e DtKWQQIcGUrQn8gKPc12/lCkIgnYG1Qmcqo+VrBY6jrcvlRmecqIX8ZmKpvV3d9GAjp6 xTeDwFAGYWY38nQK/AWKFBrBIE0wykCaq7ojRBfUn3niyhHJCN9E4dlFOZgmOEI64Ec3 qDFmtbIvGB9e5QXFW0Keujb7kcqVta41i+h6vjNrSmWUdnFVTfP7Mdf0/0H4n6Qpe/P4 R2Y0kyaz2qsSdccu7GUhCclu6FQb4Z8oFIBmG8AvYST0quhCvmMgvNSO1v/skvq/Ycl3 Filg== X-Gm-Message-State: AOPr4FWks0HyeUuMlsWwyiVT8h0S60xwDX5JLQj5f/z1CXpFp13usLyhoYhjCWVYQ8XY19Ld3cwIDxO7waH/RA== MIME-Version: 1.0 X-Received: by 10.31.162.3 with SMTP id l3mr3846588vke.68.1461134034304; Tue, 19 Apr 2016 23:33:54 -0700 (PDT) Received: by 10.31.229.129 with HTTP; Tue, 19 Apr 2016 23:33:54 -0700 (PDT) In-Reply-To: References: Date: Wed, 20 Apr 2016 07:33:54 +0100 Message-ID: Subject: Re: Spark SQL Transaction From: Mich Talebzadeh To: =?UTF-8?Q?Andr=C3=A9s_Ivaldi?= Cc: user Content-Type: multipart/alternative; boundary=001a114406ea1587010530e4c729 --001a114406ea1587010530e4c729 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Are you using JDBC to push data to MSSQL? Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrbJd6= zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 19 April 2016 at 23:41, Andr=C3=A9s Ivaldi wrote: > I mean local transaction, We've ran a Job that writes into SQLServer then > we killed spark JVM just for testing purpose and we realized that SQLServ= er > did a rollback. > > Regards > > On Tue, Apr 19, 2016 at 5:27 PM, Mich Talebzadeh < > mich.talebzadeh@gmail.com> wrote: > >> Hi, >> >> What do you mean by *without transaction*? do you mean forcing SQL Serve= r >> to accept a non logged operation? >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * https://www.linkedin.com/profile/view?id=3DAAEAAAAWh2gBxianrb= Jd6zP6AcPCCdOABUrV8Pw >> * >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> >> On 19 April 2016 at 21:18, Andr=C3=A9s Ivaldi wrote= : >> >>> Hello, is possible to execute a SQL write without Transaction? we dont >>> need transactions to save our data and this adds an overhead to the >>> SQLServer. >>> >>> Regards. >>> >>> -- >>> Ing. Ivaldi Andres >>> >> >> > > > -- > Ing. Ivaldi Andres > --001a114406ea1587010530e4c729 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Are you using JDBC to push data to MSSQL?


On 19 April 2016 at 23:41, Andr=C3=A9s Ivald= i <iaivaldi@gmail.com> wrote:
I mean local transaction, We've ran a Job that wr= ites into SQLServer then we killed spark JVM just for testing purpose and w= e realized that SQLServer did a rollback.

Regards

On Tue, Apr 19, 2016 at 5:27 PM, Mich Talebzadeh <<= a href=3D"mailto:mich.talebzadeh@gmail.com" target=3D"_blank">mich.talebzad= eh@gmail.com> wrote:
Hi,

What do you mean by *without transaction*? d= o you mean forcing SQL Server to accept a non logged operation?
=


On 19 April 2016 at 21:18, Andr=C3=A9s Ivald= i <iaivaldi@gmail.com> wrote:
Hello, is possible to execute a SQL write without Transaction? we = dont need transactions to save our data and this adds an overhead to the SQ= LServer.

Regards.

-- =
Ing. Ivaldi Andres




--
Ing. Ivaldi Andres
<= /div>

--001a114406ea1587010530e4c729--