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 5EA6C200BF6 for ; Tue, 10 Jan 2017 11:37:26 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 5D3F4160B3D; Tue, 10 Jan 2017 10:37:26 +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 A572A160B31 for ; Tue, 10 Jan 2017 11:37:25 +0100 (CET) Received: (qmail 71581 invoked by uid 500); 10 Jan 2017 10:37:24 -0000 Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@sqoop.apache.org Delivered-To: mailing list dev@sqoop.apache.org Received: (qmail 71567 invoked by uid 99); 10 Jan 2017 10:37:24 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jan 2017 10:37:24 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 18C661A068B for ; Tue, 10 Jan 2017 10:37:24 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.399 X-Spam-Level: ** X-Spam-Status: No, score=2.399 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_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001, WEIRD_PORT=0.001] autolearn=disabled Authentication-Results: spamd2-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 (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id HrhN1ahJTLgR for ; Tue, 10 Jan 2017 10:37:22 +0000 (UTC) Received: from mail-oi0-f43.google.com (mail-oi0-f43.google.com [209.85.218.43]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 05F245FAC3 for ; Tue, 10 Jan 2017 10:37:22 +0000 (UTC) Received: by mail-oi0-f43.google.com with SMTP id w204so43692818oiw.0 for ; Tue, 10 Jan 2017 02:37:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=/q53ODzXZZX0f2LatXil5jwF3id3Gw5TTdMmyLyrCXQ=; b=FamtPoYPc0kU/NMLgOzT9bgTjV45QKdfgh+Svz94WZ1qfxs5S6w+OA6v1eNeXPCpni bapj+EfTYIUHvCUfZrpzMu09OtIv3KQYVul7WZb3LrPV1D+Y9vNcIBGcGDflrBUKy6DA 58ccovflAT++0FwLhfJyemcoSiS6vN/jt2XRcuZtXgrQKD5ttXnRRKQ/7qgywgLmclwF XJvcDXYd/yxNJ+8nrOibjcee3iaq1kbWOUcv4qj7abWCcTJeHPJe+n1PkNAqbbgg19v+ h90Zy8mop+hUVoGUSESHDBlw8VWcsIWc88d4NA+eOSQXCTEZ6pEtNoSjaA6R/39E6XOW bDMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=/q53ODzXZZX0f2LatXil5jwF3id3Gw5TTdMmyLyrCXQ=; b=pl551DPmf3jrZpVVGl4LCl3Fzi96dqOw1EPGxy/SKIS0+fN3FfB8R/JZ0F29vHKhJy oAhhoxnbMO8dqRZAJGRSNjPBE6FgOxJq/ln8zoCdMM0KChQWfCUh2LLQ9l6HXsBQ+YGH okw8aO/O45YKECKRHIW1nZMlmNg4oZsTkPLidpLG4Vw0ZqtRwwqIpDapWQvdUayFBiHo BLvPbn9UEJIMvUJj60FYfcW6jo3qz80uBlPPDnNbH2/tBeEMXMY1NgMiDYfo1QpQKnKT 34R5t6hl73FroJkaBq+lLWVeG8izA19m8OGyGDZh2BS6IsEO6L82I7y7fgSpDHXmvMmQ KRkQ== X-Gm-Message-State: AIkVDXJ0RAudtATVpcgLisy4WuTvStFA9Art0kiOixcBf0KGI7tp0inMmO/ZdWoAUU27ShcMS9jql2M99BXgkA== X-Received: by 10.202.86.15 with SMTP id k15mr1098153oib.212.1484044638232; Tue, 10 Jan 2017 02:37:18 -0800 (PST) MIME-Version: 1.0 Received: by 10.182.16.72 with HTTP; Tue, 10 Jan 2017 02:36:57 -0800 (PST) In-Reply-To: References: From: wenxing zheng Date: Tue, 10 Jan 2017 18:36:57 +0800 Message-ID: Subject: Re: Problems in Sqoop2 REST API for Sqoop2 To: dev@sqoop.apache.org Content-Type: multipart/alternative; boundary=001a113d37ec7e39400545bb1170 archived-at: Tue, 10 Jan 2017 10:37:26 -0000 --001a113d37ec7e39400545bb1170 Content-Type: text/plain; charset=UTF-8 paste the error log for your reference: 2017-01-10 17:45:19,443 INFO [org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.configurePartitionProperties(GenericJdbcFromInitializer.java:152)] Using partition column: id 2017-01-10 17:45:19,443 INFO [org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.configurePartitionProperties(GenericJdbcFromInitializer.java:181)] Incremental new max value query: SELECT *MAX(``)* FROM `table`.`test_table` 2017-01-10 17:45:19,449 ERROR [org.apache.sqoop.server.SqoopProtocolServlet.doPut(SqoopProtocolServlet.java:86)] Exception in PUT http://localhost:12000/sqoop/v1/job/vcg_bi_a_account_contact_job/start org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0016:Can't fetch schema at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.initialize(GenericJdbcFromInitializer.java:64) at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.initialize(GenericJdbcFromInitializer.java:47) On Tue, Jan 10, 2017 at 6:33 PM, wenxing zheng wrote: > Dear gurus, > > I am using the Sqoop2 REST API to update the job for below items with NULL. > > "incrementalRead.checkColumn": null, "incrementalRead.lastValue": null > > But after the update, I found the checkColumn is still in "", and when I > started the job, it failed to start due to "checkColumn" is not null, but > in "". > > My questions are: > 1. How to update the the checkColumn with null to avoid the checking on > the checkColumn? > 2. If the checkColumn is being set, but if the source table's checkColumn > are all in NULL, the job will fail to. Can we support such case? > > Thanks, Wenxing > --001a113d37ec7e39400545bb1170--