From user-return-1328-archive-asf-public=cust-asf.ponee.io@kudu.apache.org Mon Apr 9 19:59:13 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id CC561180645 for ; Mon, 9 Apr 2018 19:59:11 +0200 (CEST) Received: (qmail 88898 invoked by uid 500); 9 Apr 2018 17:59:10 -0000 Mailing-List: contact user-help@kudu.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@kudu.apache.org Delivered-To: mailing list user@kudu.apache.org Received: (qmail 88872 invoked by uid 99); 9 Apr 2018 17:59:10 -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; Mon, 09 Apr 2018 17:59:10 +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 CBC8C1A06AF for ; Mon, 9 Apr 2018 17:59:09 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.679 X-Spam-Level: X-Spam-Status: No, score=0.679 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=cloudera.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 lqGFXTliwdym for ; Mon, 9 Apr 2018 17:59:07 +0000 (UTC) Received: from mail-it0-f47.google.com (mail-it0-f47.google.com [209.85.214.47]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 32E655F1EE for ; Mon, 9 Apr 2018 17:59:06 +0000 (UTC) Received: by mail-it0-f47.google.com with SMTP id b5-v6so12222492itj.1 for ; Mon, 09 Apr 2018 10:59:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cloudera.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-transfer-encoding; bh=RZO/fsY/86i22ZsWyXjtVNxvC6sEg3VlvxfYabVk530=; b=BSSHWW178t8tHG24bQkQ2PTKzg59A9skLGOH49SkSYDsNgJEuw8CPFxmROYSnV5xbs PSUgWnaAKT9xN3vgj52JkOtBMUijV1NMIMp5SwMBXbkiMgsm/5ZhWjpgLiIvGASXwge+ 4V31PJYHeZlMEutV6CNLoZyVRAwRemvvLSX/yWJsN51c0RYXAwUC17pmwWjmdiB5CUyZ qG00Udhm+Fy25b5X6073uJbdJZ7wMLY3saSXpaCjV3I4T2XrKoerWmG8Ppa/6t0+sciO OM6HMGsX9vCsjwEzDuv+aHItBy9SM5Mb2klLrMTPtkIYEZIfj8eWVZFr1JkfgzdPV1aO zhSg== 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:cc:content-transfer-encoding; bh=RZO/fsY/86i22ZsWyXjtVNxvC6sEg3VlvxfYabVk530=; b=OUZD1JyTZRVIU7aiqn9lyS/mpzF3q3nGgGS1zcFlZ6tz4ihMbdmpQ7phGza2v79lrd 4DtXsgI7C/CZlGUR6ZnQIimNscuGn2phIASTLYVBXISEi+VAbKyakS3RDYuxns4uv9A3 AFkxExGJd8RfEpxzHENVsQD/QnlOqN0YVrJxS/lI/eYtsq9rskfvCQJ2Q7o5KYUM3rZ8 vXbYJ4nw4D9tgmtnNBttYmgwTp0NwMezss6tqrKB8DQTO+KnMgZ8S1l/MsBlvqLthbMz Suvndk+IaBVHR4fv1WKMv59/glBzFH6UY/0BO/lLK6OMefrxXiMrrmxA7uradzvOiuC2 BfHA== X-Gm-Message-State: ALQs6tAXaj6odxJnbxrrvY2u8MrTmIUiaL3q9VwCQlufGsa5udlDlZnA N4CWztKi2fOw/qXzAIHbfysU6tWAatKg2BQnXL3ARjKt X-Google-Smtp-Source: AIpwx4+b4Q0XHRDtpYxFa5xhDIaQwVw8qw4ctTnbtEnvdb1bu0rmabrMzRzsFBslYuVC14wCOjiHfXXFCdeH06b8YKU= X-Received: by 2002:a24:2551:: with SMTP id g78-v6mr1135598itg.76.1523296744353; Mon, 09 Apr 2018 10:59:04 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.132.102 with HTTP; Mon, 9 Apr 2018 10:59:03 -0700 (PDT) In-Reply-To: References: From: Adar Lieber-Dembo Date: Mon, 9 Apr 2018 10:59:03 -0700 Message-ID: Subject: Re: Kudu silently failing to set nullable column To: user@kudu.apache.org Cc: Erica Chang Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This sounds like an Impala bug to me. http://issues.cloudera.org/browse/IMPALA-5217 seems relevant. Since you're using Cloudera's distribution of Impala, I took a look at Cloudera's release notes, and that bug was fixed in CDH 5.12.0, 5.11.2, and 5.10.2. So it makes sense that your Impala would be affected (CDH 5.11.1). If upgrading to an unaffected release doesn't help, maybe try asking on an Apache Impala mailing list? See https://impala.apache.org/community.html for more information. On Thu, Apr 5, 2018 at 5:30 PM, Jeff Jones wro= te: > Environment: > > impalad version 2.8.0-cdh5.11.1 RELEASE (build > 3382c1c488dff12d5ca8d049d2b59babee605b4e) > > Built on Thu Jun 1 10:36:12 PDT 2017 > > > > kudu 1.1.0 > > revision 3f64b68724ded320a31b69467c5a5f7744b07a50 > > build type RELEASE > > built by jenkins at 17 Nov 2016 00:34:09 PST on > impala-ec2-pkg-centos-7-0fe9.vpc.cloudera.com > > build id 2016-11-17_00-00-22 > > > > I have a Kudu table that I=E2=80=99m trying to update through JDBC which = fails > silently when trying to update a nullable column to null. When running th= e > update through the impala-shell it gives me a warning about violating a > nullability constraint. The table description is below. The column in > question is the sample_catalog_tags column at the bottom. > > > > Query: describe samples_v3_1_dj > > +--------------------------------------------+--------+---------+--------= -----+----------+---------------+---------------+---------------------+----= --------+ > > | name | type | comment | > primary_key | nullable | default_value | encoding | compression > | block_size | > > +--------------------------------------------+--------+---------+--------= -----+----------+---------------+---------------+---------------------+----= --------+ > > | sequence_result_id | string | | true > | false | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_id | string | | false > | false | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_name | string | | false > | false | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | species | string | | false > | false | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | locus | string | | false > | false | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | product_subtype | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | counting_method | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | primer_set | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | productive_entropy | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | productive_clonality | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_entropy | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_clonality | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_amount_ng | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_cells_mass_estimate | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | fraction_productive_of_cells_mass_estimate | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_cells | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | fraction_productive_of_cells | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | max_productive_frequency | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | max_frequency | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_templates | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | productive_templates | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | outofframe_templates | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | stop_templates | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | dj_templates | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_rearrangements | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | productive_rearrangements | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | outofframe_rearrangements | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | stop_rearrangements | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | dj_rearrangements | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_reads | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_productive_reads | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_outofframe_reads | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_stop_reads | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_dj_reads | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sequence_result_status | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | release_date | bigint | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | upload_date | bigint | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | fraction_productive | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | order_name | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | kit_id | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | kit_pool | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | owning_workspace_id | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | min_rearrangement_length | int | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | est_productive_receptors | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | est_total_receptors | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_properties | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_templates_agg | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_t_cells | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | total_t_cells_new | double | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > | sample_catalog_tags | string | | false > | true | | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 > | > > +--------------------------------------------+--------+---------+--------= -----+----------+---------------+---------------+---------------------+----= --------+ > > Fetched 50 row(s) in 0.02s > > > > When I run the update statement in the impala-shell I see the warning abo= ut > nullability and a subsequent select shows the column was not updated. > > > >> select sample_id, sequence_result_id, sample_catalog_tags from >> samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd94789= 9'); > > Query: select sample_id, sequence_result_id, sample_catalog_tags from > samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd947899= ') > > Query submitted at: 2018-04-06 00:12:21 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3Dd344cbbba783c2ce:b3be430e00000000 > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > | sample_id | sequence_result_id > | sample_catalog_tags | > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 280df143-b893-4e2b-b1e7-dfb9940aaf10 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > d10517c0-0aeb-4d73-96a6-db8ab9ca60d7 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 19154086-868e-484f-9c7d-4d62434ca571 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > fbdc1f5e-5aa8-40e2-bc64-b97af03b4c66 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > Fetched 4 row(s) in 0.23s > >> UPDATE samples_v3_1_dj SET sample_catalog_tags=3Dnull WHERE >> sequence_result_id IN ('280df143-b893-4e2b-b1e7-dfb9940aaf10'); > > Query: update samples_v3_1_dj SET sample_catalog_tags=3Dnull WHERE > sequence_result_id IN ('280df143-b893-4e2b-b1e7-dfb9940aaf10') > > Query submitted at: 2018-04-06 00:13:13 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3Df8427448b43445db:aa28650800000000 > > WARNINGS: Row with null value violates nullability constraint on table > 'impala::immunoseq_analyzer.samples_v3_1_dj'. > > > > Modified 0 row(s), 1 row error(s) in 0.34s > >> select sample_id, sequence_result_id, sample_catalog_tags from >> samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd94789= 9'); > > Query: select sample_id, sequence_result_id, sample_catalog_tags from > samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd947899= ') > > Query submitted at: 2018-04-06 00:13:18 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3De44ab2131f30dc65:eef1e66400000000 > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > | sample_id | sequence_result_id > | sample_catalog_tags | > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 280df143-b893-4e2b-b1e7-dfb9940aaf10 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > fbdc1f5e-5aa8-40e2-bc64-b97af03b4c66 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > d10517c0-0aeb-4d73-96a6-db8ab9ca60d7 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 19154086-868e-484f-9c7d-4d62434ca571 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > Fetched 4 row(s) in 0.24s > > > > > > As you can see above the column is nullable but attempting to set the col= umn > to null does not work. Below shows that there are other rows with null > values for this column. > > > >> select sample_id, sequence_result_id, sample_catalog_tags from >> samples_v3_1_dj where sample_catalog_tags is null limit 1; > > Query: select sample_id, sequence_result_id, sample_catalog_tags from > samples_v3_1_dj where sample_catalog_tags is null limit 1 > > Query submitted at: 2018-04-06 00:20:01 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3D604afe3b4fcb9c0c:364161d100000000 > > +--------------------------------------+---------------------------------= -----+---------------------+ > > | sample_id | sequence_result_id > | sample_catalog_tags | > > +--------------------------------------+---------------------------------= -----+---------------------+ > > | b76eaccd-da3f-49de-b04a-28ad3cb112d5 | > 0008df4c-01f0-4e7f-9493-954a1e0530bd | NULL | > > +--------------------------------------+---------------------------------= -----+---------------------+ > > Fetched 1 row(s) in 0.33s > > > > Now if I attempt an upsert you can see that it does in fact work. > > > >> upsert into table samples_v3_1_dj (sequence_result_id, sample_id, >> sample_name, species, locus, product_subtype, sample_catalog_tags) value= s >> ('280df143-b893-4e2b-b1e7-dfb9940aaf10', >> '1e6a74f5-8a2e-4806-b7bf-4cf1dd947899', 'SAMPLE-4', 'Human', 'TCRB', >> 'Survey', null); > > Query: upsert into table samples_v3_1_dj (sequence_result_id, sample_id, > sample_name, species, locus, product_subtype, sample_catalog_tags) values > ('280df143-b893-4e2b-b1e7-dfb9940aaf10', > '1e6a74f5-8a2e-4806-b7bf-4cf1dd947899', 'SAMPLE-4', 'Human', 'TCRB', > 'Survey', null) > > Query submitted at: 2018-04-06 00:21:44 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3Db942ea9871581947:b363f6d000000000 > > Modified 1 row(s), 0 row error(s) in 0.11s > >> select sample_id, sequence_result_id, sample_catalog_tags from >> samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd94789= 9'); > > Query: select sample_id, sequence_result_id, sample_catalog_tags from > samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd947899= ') > > Query submitted at: 2018-04-06 00:21:51 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3Df3485ee6580ae44f:b8c5242100000000 > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > | sample_id | sequence_result_id > | sample_catalog_tags | > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 280df143-b893-4e2b-b1e7-dfb9940aaf10 | NULL > | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > d10517c0-0aeb-4d73-96a6-db8ab9ca60d7 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 19154086-868e-484f-9c7d-4d62434ca571 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > fbdc1f5e-5aa8-40e2-bc64-b97af03b4c66 | Tissue > Source:Blood,Diagnosis:Diagnosis | > > +--------------------------------------+---------------------------------= -----+-----------------------------------------+ > > Fetched 4 row(s) in 0.33s > > > > I suppose I could change my update to an upsert=E2=80=A6select=E2=80=A6fr= om but it=E2=80=99s still > bugging me that the update isn=E2=80=99t working. > > > >> upsert into table samples_v3_1_dj (sequence_result_id, sample_id, >> sample_name, species, locus, product_subtype, sample_catalog_tags) selec= t >> sequence_result_id, sample_id, sample_name, species, locus, product_subt= ype, >> null from samples_v3_1_dj where sample_id =3D >> '1e6a74f5-8a2e-4806-b7bf-4cf1dd947899'; > > Query: upsert into table samples_v3_1_dj (sequence_result_id, sample_id, > sample_name, species, locus, product_subtype, sample_catalog_tags) select > sequence_result_id, sample_id, sample_name, species, locus, product_subty= pe, > null from samples_v3_1_dj where sample_id =3D > '1e6a74f5-8a2e-4806-b7bf-4cf1dd947899' > > Query submitted at: 2018-04-06 00:28:28 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3D8d422b3c7ff44356:69fa874300000000 > > Modified 4 row(s), 0 row error(s) in 0.44s > >> select sample_id, sequence_result_id, sample_catalog_tags from >> samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd94789= 9'); > > Query: select sample_id, sequence_result_id, sample_catalog_tags from > samples_v3_1_dj WHERE sample_id IN ('1e6a74f5-8a2e-4806-b7bf-4cf1dd947899= ') > > Query submitted at: 2018-04-06 00:28:34 (Coordinator: http://...:25000) > > Query progress can be monitored at: > http://...:25000/query_plan?query_id=3D447bcd28973cd84:b76c1b2b00000000 > > +--------------------------------------+---------------------------------= -----+---------------------+ > > | sample_id | sequence_result_id > | sample_catalog_tags | > > +--------------------------------------+---------------------------------= -----+---------------------+ > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > fbdc1f5e-5aa8-40e2-bc64-b97af03b4c66 | NULL | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > d10517c0-0aeb-4d73-96a6-db8ab9ca60d7 | NULL | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 19154086-868e-484f-9c7d-4d62434ca571 | NULL | > > | 1e6a74f5-8a2e-4806-b7bf-4cf1dd947899 | > 280df143-b893-4e2b-b1e7-dfb9940aaf10 | NULL | > > +--------------------------------------+---------------------------------= -----+---------------------+ > > Fetched 4 row(s) in 0.17s > > > > Any thoughts on how I could get the update to work? > > > > Thanks, > Jeff > > > > This message (and any attachments) is intended only for the designated > recipient(s). It > may contain confidential or proprietary information, or have other > limitations on use as > indicated by the sender. If you are not a designated recipient, you may n= ot > review, use, > copy or distribute this message. If you received this in error, please > notify the sender by > reply e-mail and delete this message.