| /* |
| * 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. |
| */ |
| |
| USE TestYelp; |
| |
| UPSERT INTO YelpCheckin ( |
| [ |
| { |
| "business_id": "--1UhMGODdWsrMastO9DZw", |
| "dates": [ |
| "2016-04-26 19:49:16", |
| "2016-08-30 18:36:57", |
| "2016-10-15 02:45:18", |
| "2016-11-18 01:54:50", |
| "2017-04-20 18:39:06", |
| "2017-05-03 17:58:02", |
| "2019-03-19 22:04:48" |
| ] |
| }, |
| { |
| "business_id": "--EF5N7P70J_UYBTPypYlA", |
| "dates": [ |
| "2018-05-25 19:52:07", |
| "2018-09-18 16:09:44", |
| "2019-10-18 21:29:09" |
| ] |
| }, |
| { |
| "business_id": "--Ni3oJ4VOqfOEu7Sj2Vzg", |
| "dates": [ |
| "2019-06-07 17:54:58" |
| ] |
| }, |
| { |
| "business_id": "--Y1Adl1YUWfYIRSd8vkmA", |
| "dates": [ |
| "2011-05-03 20:54:05", |
| "2011-08-23 20:49:45", |
| "2014-12-04 06:13:01", |
| "2016-11-16 19:25:55" |
| ] |
| }, |
| { |
| "business_id": "--YPwqIlRJrhHkJcjY3eiA", |
| "dates": [ |
| "2016-06-18 21:35:45", |
| "2016-10-15 18:17:51" |
| ] |
| }, |
| { |
| "business_id": "--e8PjCNhEz32pprnPhCwQ", |
| "dates": [ |
| "2015-04-02 21:45:17" |
| ] |
| }, |
| { |
| "business_id": "--kinfHwmtdjz03g8B8z8Q", |
| "dates": [ |
| "2014-08-27 17:49:18", |
| "2015-12-19 21:30:31", |
| "2018-11-27 15:53:50" |
| ] |
| }, |
| { |
| "business_id": "--q6datkI-f0EoVheXNEeQ", |
| "dates": [ |
| "2014-01-28 20:56:04", |
| "2014-11-16 16:11:58", |
| "2015-11-15 19:21:53", |
| "2015-11-15 19:33:39" |
| ] |
| }, |
| { |
| "business_id": "--qvQS4MigHPykD2GV0-zw", |
| "dates": [ |
| "2019-04-11 18:30:12" |
| ] |
| }, |
| { |
| "business_id": "--wIGbLEhlpl_UeAIyDmZQ", |
| "dates": [ |
| "2015-06-06 20:01:06", |
| "2019-03-14 22:01:52" |
| ] |
| }, |
| { |
| "business_id": "-0FA-Qdi3SPYIoJz9UQw-A", |
| "dates": [ |
| "2018-09-29 18:55:17", |
| "2018-10-20 16:48:05", |
| "2018-10-20 22:20:24" |
| ] |
| }, |
| { |
| "business_id": "-0Hj1hb_XW6ybWq2M7QhGA", |
| "dates": [ |
| "2011-04-23 21:11:22", |
| "2014-05-04 19:42:48", |
| "2014-05-11 19:16:08", |
| "2014-06-04 19:14:18", |
| "2015-12-05 19:22:42", |
| "2017-05-15 23:19:00" |
| ] |
| }, |
| { |
| "business_id": "-0KMvRFwDWdVBeTpT11iHw", |
| "dates": [ |
| "2012-07-13 21:43:57", |
| "2016-12-24 02:27:31", |
| "2017-08-31 00:35:26" |
| ] |
| }, |
| { |
| "business_id": "-0LPtgJC31FWMrMv317p0Q", |
| "dates": [ |
| "2013-04-13 12:35:33", |
| "2013-08-19 23:35:49", |
| "2013-10-04 19:14:56" |
| ] |
| }, |
| { |
| "business_id": "-0M3o2uWBnQZwd3hmfEwuw", |
| "dates": [ |
| "2016-09-10 19:26:19", |
| "2018-09-08 14:15:37", |
| "2019-09-13 22:47:25" |
| ] |
| }, |
| { |
| "business_id": "-0RRiWDtfnS16AKCtfvBZg", |
| "dates": [ |
| "2017-05-19 14:30:16", |
| "2017-05-19 14:30:25", |
| "2017-08-28 15:49:37", |
| "2017-09-20 20:19:51", |
| "2017-10-01 16:31:05", |
| "2017-10-01 16:56:27", |
| "2017-12-27 23:33:20" |
| ] |
| }, |
| { |
| "business_id": "-0Soj75v-XoRcf2ERr8Bmg", |
| "dates": [ |
| "2019-06-05 18:22:49" |
| ] |
| }, |
| { |
| "business_id": "-0ZumLlFjMh4ZW1z2nXGug", |
| "dates": [ |
| "2011-09-24 21:37:32", |
| "2014-03-10 20:20:07", |
| "2015-05-27 00:40:24", |
| "2015-08-29 17:58:15", |
| "2018-03-16 15:03:26" |
| ] |
| }, |
| { |
| "business_id": "-0aOudcaAyac0VJbMX-L1g", |
| "dates": [ |
| "2015-03-16 23:51:16", |
| "2015-12-21 04:48:01", |
| "2016-10-28 20:22:42", |
| "2016-10-28 20:23:00" |
| ] |
| }, |
| { |
| "business_id": "-0b86isaXMY0v4g-V8GZ9Q", |
| "dates": [ |
| "2013-10-22 16:49:21", |
| "2014-11-21 17:39:24" |
| ] |
| }, |
| { |
| "business_id": "-0d-BfFSU0bwLcnMaGRxYw", |
| "dates": [ |
| "2014-08-07 18:30:48", |
| "2014-09-16 20:41:45", |
| "2014-10-12 23:22:27", |
| "2015-07-21 20:43:56", |
| "2015-07-21 20:45:07" |
| ] |
| }, |
| { |
| "business_id": "-0jz6c3C6i7RG7Ag22K-Pg", |
| "dates": [ |
| "2015-05-02 19:49:05", |
| "2015-05-06 03:52:18", |
| "2015-09-26 01:13:19" |
| ] |
| }, |
| { |
| "business_id": "-0y3MZU2oYP8r1ruDP1bfQ", |
| "dates": [ |
| "2015-04-11 13:14:14", |
| "2015-11-21 16:05:56", |
| "2016-05-06 14:10:04", |
| "2017-08-09 15:15:10", |
| "2017-10-21 15:12:56" |
| ] |
| }, |
| { |
| "business_id": "-1BPe8UjF2_l3nVk-DFUjA", |
| "dates": [ |
| "2015-12-03 18:44:00", |
| "2016-03-17 18:19:21", |
| "2016-11-02 15:58:38" |
| ] |
| }, |
| { |
| "business_id": "-1E2CQu_38mkghvmZgCCRw", |
| "dates": [ |
| "2019-04-04 22:02:37" |
| ] |
| }, |
| { |
| "business_id": "-1wzk43IZ5D9Ysu6kzb5xA", |
| "dates": [ |
| "2019-02-27 14:03:08" |
| ] |
| }, |
| { |
| "business_id": "-23R9P2eG7VTc6DVLjFKzA", |
| "dates": [ |
| "2011-12-21 19:02:51", |
| "2012-04-15 04:21:39", |
| "2012-04-15 14:23:56", |
| "2013-06-30 22:39:51", |
| "2013-10-04 20:34:13", |
| "2014-07-16 02:28:40" |
| ] |
| }, |
| { |
| "business_id": "-26MGfikhJiTfCI-GqmzhQ", |
| "dates": [ |
| "2018-06-13 20:16:07" |
| ] |
| }, |
| { |
| "business_id": "-2bLuJsMZ0WhI9daurVQNQ", |
| "dates": [ |
| "2015-05-29 16:46:17", |
| "2015-06-01 15:03:53" |
| ] |
| }, |
| { |
| "business_id": "-2hDBMaza_ldqnZdiU06LQ", |
| "dates": [ |
| "2011-10-08 12:02:23", |
| "2014-08-18 02:11:11", |
| "2016-01-07 05:27:51", |
| "2016-10-21 20:15:55", |
| "2016-12-01 03:57:10", |
| "2016-12-29 01:54:42", |
| "2018-07-22 19:55:31", |
| "2018-09-07 01:42:54", |
| "2019-03-08 03:41:06" |
| ] |
| } |
| ] |
| ); |