asterixdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ima...@apache.org
Subject [1/3] asterixdb git commit: Tests for ASTERIXDB-1636
Date Thu, 06 Oct 2016 05:38:19 GMT
Repository: asterixdb
Updated Branches:
  refs/heads/master 0309d51a5 -> ecba52e0b


http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql
new file mode 100644
index 0000000..190891f
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql
@@ -0,0 +1,81 @@
+/*
+ * 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.
+ */
+
+ /*
+ * Description  : Reproduction scenario for ASTERIXDB-1636
+ * Expected Res : Success
+ * Date         : Oct 5th 2016
+ */
+
+drop dataverse twitter if exists;
+create dataverse twitter if not exists;
+use dataverse twitter
+create type typeUser if not exists as open {
+    id: int64,
+    name: string,
+    screen_name : string,
+    lang : string,
+    location: string,
+    create_at: date,
+    description: string,
+    followers_count: int32,
+    friends_count: int32,
+    statues_count: int64
+}
+create type typePlace if not exists as open{
+    country : string,
+    country_code : string,
+    full_name : string,
+    id : string,
+    name : string,
+    place_type : string,
+    bounding_box : rectangle
+}
+create type typeGeoTag if not exists as open {
+    stateID: int32,
+    stateName: string,
+    countyID: int32,
+    countyName: string,
+    cityID: int32?,
+    cityName: string?
+}
+create type typeTweet if not exists as open{
+    create_at : datetime,
+    id: int64,
+    "text": string,
+    in_reply_to_status : int64,
+    in_reply_to_user : int64,
+    favorite_count : int64,
+    coordinate: point?,
+    retweet_count : int64,
+    lang : string,
+    is_retweet: boolean,
+    hashtags : {{ string }} ?,
+    user_mentions : {{ int64 }} ? ,
+    user : typeUser,
+    place : typePlace?,
+    geo_tag: typeGeoTag
+}
+
+create dataset ds_tweet(typeTweet) if not exists primary key id with filter on create_at;
+create index text_idx if not exists on ds_tweet("text") type keyword;
+create feed MessageFeed using localfs(
+("path"="localhost://../../../../../src/test/resources/integrationts/restart/828.h1w.adm"),
+("format"="adm"),
+("type-name"="typeTweet"));

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql
new file mode 100644
index 0000000..58dea6b
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql
@@ -0,0 +1,27 @@
+/*
+ * 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.
+ */
+
+ /*
+ * Description  : Reproduction scenario for ASTERIXDB-1636
+ * Expected Res : Success
+ * Date         : Oct 5th 2016
+ */
+
+use dataverse twitter;
+connect feed MessageFeed to dataset ds_tweet;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql
new file mode 100644
index 0000000..d489e74
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql
@@ -0,0 +1 @@
+touch.sh
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql
new file mode 100644
index 0000000..cf520ca
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql
@@ -0,0 +1,35 @@
+/*
+ * 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.
+ */
+
+ /*
+ * Description  : Reproduction scenario for ASTERIXDB-1636
+ * Expected Res : Success
+ * Date         : Oct 5th 2016
+ */
+
+use dataverse twitter;
+drop feed TweetFeed if exists;
+create feed TweetFeed using localfs
+(
+    ("path"="localhost://../../../../../target/tweets.json"),
+    ("format"="adm"),
+    ("type-name"="typeTweet")
+);
+set wait-for-completion-feed "true";
+connect feed TweetFeed to dataset ds_tweet;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql
new file mode 100644
index 0000000..d6e839a
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql
@@ -0,0 +1,2 @@
+stop -n asterix
+

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql
new file mode 100644
index 0000000..1d6d3bc
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql
@@ -0,0 +1,2 @@
+start -n asterix
+

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql
new file mode 100644
index 0000000..7503842
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql
@@ -0,0 +1 @@
+cat.sh

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql
new file mode 100644
index 0000000..860b8ed
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql
@@ -0,0 +1,27 @@
+/*
+ * 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.
+ */
+
+ /*
+ * Description  : Reproduction scenario for ASTERIXDB-1636
+ * Expected Res : Success
+ * Date         : Oct 5th 2016
+ */
+use dataverse twitter;
+set wait-for-completion-feed "false";
+connect feed TweetFeed to dataset ds_tweet;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql
new file mode 100644
index 0000000..49ccbce
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql
@@ -0,0 +1,25 @@
+/*
+ * 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.
+ */
+
+ /*
+ * Description  : Reproduction scenario for ASTERIXDB-1636
+ * Expected Res : Success
+ * Date         : Oct 5th 2016
+ */
+1000
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql
new file mode 100644
index 0000000..80bfb2c
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql
@@ -0,0 +1 @@
+kill_cc_and_nc.sh

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql
new file mode 100644
index 0000000..d599fbe
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql
@@ -0,0 +1 @@
+grep_log.sh
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh
new file mode 100755
index 0000000..c111fde
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh
@@ -0,0 +1,18 @@
+#!/usr/bin/env bash
+# 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.
+cat src/test/resources/integrationts/restart/tweets.json > target/tweets.json

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh
new file mode 100755
index 0000000..b84732f
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh
@@ -0,0 +1,20 @@
+#!/usr/bin/env bash
+# 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.
+if grep --quiet -m 1 'java.lang.ArrayIndexOutOfBoundsException' target/asterix-installer-*-binary-assembly/clusters/local/working_dir/logs/*.log ; then
+    echo "ERROR"
+fi

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh
new file mode 100755
index 0000000..2582713
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh
@@ -0,0 +1,18 @@
+#!/usr/bin/env bash
+# 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.
+jps | awk '{if ($2 == "NCDriver" || $2 == "CCDriver") print $1;}' | xargs -n 1 kill -9

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh
new file mode 100755
index 0000000..4e0b75c
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh
@@ -0,0 +1,21 @@
+#!/usr/bin/env bash
+# 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.
+if [ -f target/tweets.json ]; then
+    rm -f target/tweets.json
+fi
+touch target/tweets.json
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml
new file mode 100644
index 0000000..44ae9b4
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml
@@ -0,0 +1,28 @@
+<!--
+ ! 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.
+ !-->
+<test-suite xmlns="urn:xml.testframework.asterix.apache.org" ResultOffsetPath="results" QueryOffsetPath="queries" QueryFileExtension=".aql">
+  <test-group name="restart">
+      <test-case FilePath="feed-restart">
+        <compilation-unit name="issue-1636">
+          <output-dir compare="Text">issue-1636</output-dir>
+        </compilation-unit>
+      </test-case>
+  </test-group>
+</test-suite>
+

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json
new file mode 100644
index 0000000..d9fca06
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json
@@ -0,0 +1,39 @@
+{"create_at":datetime("2016-09-23T12:25:34.000"),"id":int64("779401340485271552"),"text":"https://t.co/90HQQzJDie","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Richmond, VA","id":"00f751614d8ce37b","name":"Richmond","place_type":"city","bounding_box":rectangle("-77.601044,37.447046 -77.385297,37.61272")},"geo_tag":{"stateID":51,"stateName":"Virginia","countyID":51760,"countyName":"Richmond","cityID":5167000,"cityName":"Richmond"},"user":{"id":int64("732261848024809473"),"name":"KUnderwood","screen_name":"KUnderw63665020","lang":"en","location":"Virginia, USA","create_at":date("2016-05-16"),"description":"*Riding On The Trump Train!*\nNO LISTS!\nRETWEETS CIRCULATE INFO THAT MSM WILL NOT!RETWEET ALL INFO GET PPL INFORMED!KNOWLEDGE IS OUR WEAPON!","followers_count":2239,"friends_count":2637,"statues_coun
 t":37837}}
+{"create_at":datetime("2016-09-23T12:25:48.000"),"id":int64("779401398928584704"),"text":"I think they should extend #SuicidePreventionAwarenessMonth from Sept until after the election, and permanently if Trump wins.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"SuicidePreventionAwarenessMonth"}},"place":{"country":"United States","country_code":"United States","full_name":"Fort Worth, TX","id":"42e46bc3663a4b5f","name":"Fort Worth","place_type":"city","bounding_box":rectangle("-97.538285,32.569477 -97.033542,32.990456")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48439,"countyName":"Tarrant","cityID":4827000,"cityName":"Fort Worth"},"user":{"id":int64("25033519"),"name":"Lily Barreda","screen_name":"lbarreda","lang":"en","location":"Fort Worth, TX","create_at":date("2009-03-17"),"description":"Dog mom, brain injury survivor-ish, really bad at writing bi
 os.","followers_count":2363,"friends_count":304,"statues_count":1438}}
+{"create_at":datetime("2016-09-23T12:25:57.000"),"id":int64("779401435486093312"),"text":"Trump called Cruz a liar & his wife ugly, so Cruz is endorsing Trump. It's the kindergarten equivalent of pulling hair of the girl you like.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Seattle, WA","id":"300bcc6e23a88361","name":"Seattle","place_type":"city","bounding_box":rectangle("-122.436232,47.495315 -122.224973,47.734319")},"geo_tag":{"stateID":53,"stateName":"Washington","countyID":53033,"countyName":"King","cityID":5363000,"cityName":"Seattle"},"user":{"id":int64("274147256"),"name":"JHunterJokes","screen_name":"jhuntercomedy","lang":"en","location":"seattle, washington","create_at":date("2011-03-29"),"description":"stand up. comedy writer. None of my tweets are based on fact. Except those about the #LAD
 odgers #Redskins, my dogs, and beer.","followers_count":1072,"friends_count":1111,"statues_count":18889}}
+{"create_at":datetime("2016-09-23T12:26:14.000"),"id":int64("779401506772676608"),"text":"Eric Trump: My dad is the epitome of the American dream! He started with barely anything!\n\nMe: https://t.co/sdNNukaYRw","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Manhattan, NY","id":"01a9a39529b27f36","name":"Manhattan","place_type":"city","bounding_box":rectangle("-74.026675,40.683935 -73.910408,40.877483")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36061,"countyName":"New York","cityID":36061,"cityName":"Manhattan"},"user":{"id":int64("39267537"),"name":"Lucy Flawless","screen_name":"everythingsjake","lang":"en","location":"New York, NY","create_at":date("2009-05-11"),"description":"I could care.","followers_count":3283,"friends_count":417,"statues_count":161030}}
+{"create_at":datetime("2016-09-23T12:26:21.000"),"id":int64("779401534622736384"),"text":"Trump bunk... https://t.co/dNDg6SkmCg","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Brookdale, CA","id":"01289bf759f2ab45","name":"Brookdale","place_type":"city","bounding_box":rectangle("-122.122065,37.089913 -122.085464,37.113252")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6087,"countyName":"Santa Cruz","cityID":608478,"cityName":"Brookdale"},"user":{"id":int64("44959505"),"name":"nancy bowen","screen_name":"lavenderblue27","lang":"en","location":"Brookdale, CA","create_at":date("2009-06-05"),"description":"Fairness, human rights & laughter, I think for myself, avid Olbermann, John Fugelsang, Beatles, John Clark, Jack Reacher fan #UniteBlue","followers_count":21429,"friends_count":21797,"statue
 s_count":291006}}
+{"create_at":datetime("2016-09-23T12:26:22.000"),"id":int64("779401539894915072"),"text":"@JkgaddisJulie @CelesteHerget @ejoy2270 @StatesPoll agreed! Trump creates jobs! Look at his resume","in_reply_to_status":int64("779352835573985280"),"in_reply_to_user":int64("1340907289"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{1340907289,930575720,705433853289082880,4547869279}},"place":{"country":"United States","country_code":"United States","full_name":"Sterling, IL","id":"6ba87c2e2d3960d0","name":"Sterling","place_type":"city","bounding_box":rectangle("-89.771235,41.772244 -89.640186,41.827767")},"geo_tag":{"stateID":17,"stateName":"Illinois","countyID":17195,"countyName":"Whiteside","cityID":1772546,"cityName":"Sterling"},"user":{"id":int64("2752932015"),"name":"Kelley MD\u2764\uFE0FTrump","screen_name":"guthrie_kelley","lang":"en","location":"United States","create_at":date("2014-08-27"),"description":"M.D. and MSW . full ti
 me doc @ Federal public health dept. I'm a Mainer. now in IL. land locked. Christian !! Jesus calling.....the book to own. :)","followers_count":1900,"friends_count":189,"statues_count":13912}}
+{"create_at":datetime("2016-09-23T12:26:23.000"),"id":int64("779401543728652288"),"text":"If equality to some means hating all men and blaming them for all their problems and 2 failed relationships. YOU are more RETARED than Trump","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Savage, MD","id":"013e2fa93b1bd0be","name":"Savage","place_type":"city","bounding_box":rectangle("-76.852175,39.120076 -76.776884,39.179931")},"geo_tag":{"stateID":24,"stateName":"Maryland","countyID":24027,"countyName":"Howard","cityID":2470475,"cityName":"Savage"},"user":{"id":int64("446473873"),"name":"Oscar Villalobos","screen_name":"mistafuntastic","lang":"en","location":"Beltsville, MD ","create_at":date("2011-12-25"),"description":"@UoPeople #Dreamer #DCUnited \u26AB\uFE0F\u26BD\uFE0F #STEM #MLS #Physics","followers_count":
 218,"friends_count":235,"statues_count":13741}}
+{"create_at":datetime("2016-09-23T12:26:24.000"),"id":int64("779401550976258048"),"text":"WHAT IS THIS NONSENSE @KimKardashian ALSO @Caitlyn_Jenner GURL BYE https://t.co/G3pi9wJZSX","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{25365536,3303293865}},"place":{"country":"United States","country_code":"United States","full_name":"Odessa, TX","id":"2c0346ba4b733e24","name":"Odessa","place_type":"city","bounding_box":rectangle("-102.434966,31.792563 -102.253208,31.955114")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48135,"countyName":"Ector","cityID":4853388,"cityName":"Odessa"},"user":{"id":int64("152033213"),"name":"ERNEST-O","screen_name":"emacys","lang":"en","location":"TEXAS \u272F","create_at":date("2010-06-04"),"description":"journalist / producer / currently rolling my eyes / aggressive @kimkardashian stan /","followers_count":602,"friends_count":
 1223,"statues_count":19777}}
+{"create_at":datetime("2016-09-23T12:26:27.000"),"id":int64("779401559415357440"),"text":"\"Look at me! Look at me! Hey, LOOK AT ME!\" https://t.co/Aog5ZWQeE1","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Manhattan, NY","id":"01a9a39529b27f36","name":"Manhattan","place_type":"city","bounding_box":rectangle("-74.026675,40.683935 -73.910408,40.877483")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36061,"countyName":"New York","cityID":36061,"cityName":"Manhattan"},"user":{"id":int64("995194771"),"name":"Steven Beck","screen_name":"becksnyc78","lang":"en","location":"New York","create_at":date("2012-12-07"),"description":"Florida born. NYC living. Wilhelmina Model. Runner. Photography. BUCS. FSU. MUFC.","followers_count":847,"friends_count":706,"statues_count":39316}}
+{"create_at":datetime("2016-09-23T12:26:31.000"),"id":int64("779401579803836416"),"text":"If they don't want to be considered enemies, let them come out and endorse DONAL J. TRUMP for president.\nDump the DOPE SMOKER.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Astatula, FL","id":"dbbd875df397a247","name":"Astatula","place_type":"city","bounding_box":rectangle("-81.747783,28.701654 -81.714374,28.727329")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12069,"countyName":"Lake","cityID":1202250,"cityName":"Astatula"},"user":{"id":int64("730763692007002112"),"name":"R A Sutton","screen_name":"rodger_sutton","lang":"en","location":"Central FLORIDA","create_at":date("2016-05-12"),"description":"United States Marine.\nFather,Grandfather,GREAT GRANDFATHER \nTrue Son of the Confederacy.\nAmerican 
 Patriot, R.E.D.\nUS FREEDOM ARMY\nNRA Golden Eagle Member","followers_count":277,"friends_count":22,"statues_count":15286}}
+{"create_at":datetime("2016-09-23T12:26:34.000"),"id":int64("779401589417086976"),"text":"@MarkCubanFans @mcuban_NBA The 14 year old that owns an NBA team. Maybe he'll stick his tongue out at Trump.\u2026 https://t.co/VPYKYwngqj","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("614301557"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{614301557,716296544278851585}},"place":{"country":"United States","country_code":"United States","full_name":"Spokane, WA","id":"dc3747428fa88cab","name":"Spokane","place_type":"city","bounding_box":rectangle("-117.565226,47.5742 -117.303868,47.760676")},"geo_tag":{"stateID":53,"stateName":"Washington","countyID":53063,"countyName":"Spokane","cityID":5367000,"cityName":"Spokane"},"user":{"id":int64("3321633224"),"name":"DeplorableDBlack15NC","screen_name":"dblack15nc","lang":"en","location":"null","create_at":date("2015-08-20"),"description":"Catholic Gentleman. 4th Degree KoC. Retired
  USAF Senior NCO. DAV, VFW, VVA, AmLegion, Sons of Confederate Veterans, Unreconstructed Tar Heel. #MAGA","followers_count":1352,"friends_count":1474,"statues_count":23047}}
+{"create_at":datetime("2016-09-23T12:26:36.000"),"id":int64("779401599127093248"),"text":"My house is surrounded with trump supporters lol","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"North Royalton, OH","id":"4506ca1d65ca5b4d","name":"North Royalton","place_type":"city","bounding_box":rectangle("-81.785322,41.264708 -81.70169,41.350954")},"geo_tag":{"stateID":39,"stateName":"Ohio","countyID":39035,"countyName":"Cuyahoga","cityID":3957008,"cityName":"North Royalton"},"user":{"id":int64("120509237"),"name":"Mahmood A","screen_name":"yung_mood","lang":"en","location":"null","create_at":date("2010-03-06"),"description":"Yemeni! BAY AREA!!! living in CLE. IG mahmood_a snapchat mood1996","followers_count":1324,"friends_count":638,"statues_count":6930}}
+{"create_at":datetime("2016-09-23T12:26:51.000"),"id":int64("779401661273870336"),"text":"Why Are There Any Liberals Supporting Gary Johnson?\nhttps://t.co/KCOQqQrhaY","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Rancho Cucamonga, CA","id":"36ac79e68ace76e4","name":"Rancho Cucamonga","place_type":"city","bounding_box":rectangle("-117.637862,34.077184 -117.486443,34.166156")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6071,"countyName":"San Bernardino","cityID":659451,"cityName":"Rancho Cucamonga"},"user":{"id":int64("611001007"),"name":"#M","screen_name":"digitalbooger","lang":"en","location":"Rancho Cucamonga","create_at":date("2012-06-17"),"description":"Rams back! Dodgers Lakers Kings USC Duke Bsktbl REM Who Tull U2 Floyd! Liberal Pacifist/Warmonger Chico St. alum AbsurdistNerd 1st S
 ci Fi novel coming","followers_count":1339,"friends_count":1502,"statues_count":7000}}
+{"create_at":datetime("2016-09-23T12:26:52.000"),"id":int64("779401665518637056"),"text":"@maddow @tedcruz @MSNBC , you are shame to the people to USA if you endorse Trump. where are your balls??","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("16129920"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{16129920,23022687,2836421}},"place":{"country":"United States","country_code":"United States","full_name":"Delray Beach, FL","id":"b4a0e9082dcc8436","name":"Delray Beach","place_type":"city","bounding_box":rectangle("-80.13094,26.420813 -80.05542,26.491482")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12099,"countyName":"Palm Beach","cityID":1217100,"cityName":"Delray Beach"},"user":{"id":int64("199408437"),"name":"Nidia Gerlach","screen_name":"mamamia909","lang":"en","location":"Delray Beach, Fl. ","create_at":date("2010-10-06"),"description":"Nos encanta ser parte del progreso de nuestro pais. We love t
 o be part of the progress of our Country.","followers_count":330,"friends_count":1491,"statues_count":1651}}
+{"create_at":datetime("2016-09-23T12:26:52.000"),"id":int64("779401667477250048"),"text":"#johnmccain #kellyayotte #ronjohnson #robportman #PatToomey #RichardBurr #markkirk #chuckgrassley \n #trump #gop\nhttps://t.co/YAVjNZ4NxD","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"hashtags":{{"johnmccain","kellyayotte","ronjohnson","robportman","PatToomey","RichardBurr","markkirk","chuckgrassley","trump","gop"}},"place":{"country":"United States","country_code":"United States","full_name":"San Francisco, CA","id":"5a110d312052166f","name":"San Francisco","place_type":"city","bounding_box":rectangle("-122.514926,37.708075 -122.357031,37.833238")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6075,"countyName":"San Francisco","cityID":667000,"cityName":"San Francisco"},"user":{"id":int64("216205407"),"name":"Ken Holsclaw","screen_name":"KenHolsclaw","lang":"en","location":"E
 arth","create_at":date("2010-11-15"),"description":"Basically good,kind, and smart. Hate bigots,false prophets, and mixing politics and religion. Killing women and children in a war should never be intentional.","followers_count":608,"friends_count":561,"statues_count":46347}}
+{"create_at":datetime("2016-09-23T12:26:55.000"),"id":int64("779401678567067648"),"text":"@MCuban will sit front row at debates. @HillaryClinton guest. Will he make #DonaldTrump squirm? #SiSePuede https://t.co/uG0HzbBULk","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("16228398"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"DonaldTrump","SiSePuede"}},"user_mentions":{{16228398,1339835893}},"place":{"country":"United States","country_code":"United States","full_name":"Dallas, TX","id":"18810aa5b43e76c7","name":"Dallas","place_type":"city","bounding_box":rectangle("-96.977527,32.620678 -96.54598,33.019039")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48113,"countyName":"Dallas","cityID":4819000,"cityName":"Dallas"},"user":{"id":int64("63619403"),"name":"Wise Latinas Linked","screen_name":"wiselatinaslink","lang":"en","location":"USA","create_at":date("2009-08-06"),"description":"#Latina #Influencers #activis
 ts big block #voters & #consumers, recognized by 2011 & 2013 @LATISM social media leaders | Latina group on #Facebook w/ 7K members","followers_count":8087,"friends_count":5416,"statues_count":19195}}
+{"create_at":datetime("2016-09-23T12:26:55.000"),"id":int64("779401679787610112"),"text":"I still think that Ted Cruz is gonna Rick Roll Trump just like he did at the convention. They're both ass hats like that.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Phoenix, AZ","id":"5c62ffb0f0f3479d","name":"Phoenix","place_type":"city","bounding_box":rectangle("-112.323914,33.29026 -111.925439,33.815465")},"geo_tag":{"stateID":4,"stateName":"Arizona","countyID":4013,"countyName":"Maricopa","cityID":455000,"cityName":"Phoenix"},"user":{"id":int64("25761955"),"name":"Tony Hernandez","screen_name":"HernandezTony","lang":"en","location":"Phoenix, AZ","create_at":date("2009-03-21"),"description":"Author","followers_count":985,"friends_count":583,"statues_count":35384}}
+{"create_at":datetime("2016-09-23T12:27:00.000"),"id":int64("779401699291168768"),"text":"@tedcruz HOWS YOUR DAD TODAY!!! IS IT REALLY WORTH IT!!! \uD83D\uDC4E\uD83C\uDFFD\uD83D\uDC4E\uD83D\uDC4E\uD83C\uDFFC\uD83D\uDC4E\uD83C\uDFFF\uD83D\uDC4E\uD83C\uDFFE\uD83D\uDC4E\uD83C\uDFFB\uD83D\uDC36\u274C\uD83D\uDC36\u274C\uD83D\uDC36\u274C\uD83D\uDC36 https://t.co/6MxunVNs8M","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("23022687"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{23022687}},"place":{"country":"United States","country_code":"United States","full_name":"Shinnecock Hills, NY","id":"a34194954d3e5af3","name":"Shinnecock Hills","place_type":"city","bounding_box":rectangle("-72.484145,40.875807 -72.43394,40.897898")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36103,"countyName":"Suffolk","cityID":3667048,"cityName":"Shinnecock Hills"},"user":{"id":int64("766964096126320640"),"name":"Corey B.","scree
 n_name":"Coreybez1","lang":"en","location":"Shinnecock Hills, NY","create_at":date("2016-08-20"),"description":"null","followers_count":792,"friends_count":1865,"statues_count":15868}}
+{"create_at":datetime("2016-09-23T12:27:03.000"),"id":int64("779401710523383808"),"text":"Hillary on Inner City Youth \n\"Bring to Heel\"\nhttps://t.co/KyV1g5EXYP\n\nTrump - \"Spend Billions\" on Inner City Youth \nhttps://t.co/PypeKtGTcJ","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"San Juan Capistrano, CA","id":"4aea239b6a146e77","name":"San Juan Capistrano","place_type":"city","bounding_box":rectangle("-117.686553,33.466555 -117.611591,33.54673")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6059,"countyName":"Orange","cityID":668028,"cityName":"San Juan Capistrano"},"user":{"id":int64("187059363"),"name":"Flavius Aetius","screen_name":"StupidBoomers","lang":"en","location":"The Titanic State or CA","create_at":date("2010-09-04"),"description":"The Worst Generation-Liberal Baby Boomers
 -are destroying USA w their selfish, greedy & unsustainable entitlement policies-Young Vet-Media Bias MUST STOP","followers_count":13932,"friends_count":15315,"statues_count":147185}}
+{"create_at":datetime("2016-09-23T12:27:08.000"),"id":int64("779401732208066561"),"text":"Reality tv stars stick together ? Imagine the episode Kim K will film at White House if Donald is president :-) https://t.co/YVKUnW3G7V","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Princeton, NJ","id":"c833fbabba6fe48e","name":"Princeton","place_type":"city","bounding_box":rectangle("-74.710297,40.32495 -74.619759,40.37435")},"geo_tag":{"stateID":34,"stateName":"New Jersey","countyID":34021,"countyName":"Mercer","cityID":3460900,"cityName":"Princeton"},"user":{"id":int64("305318105"),"name":"Steven Strauss","screen_name":"Steven_Strauss","lang":"en","location":"Cambridge and Princeton ","create_at":date("2011-05-25"),"description":"John L. Weinberg/Goldman Sachs & Co. Visiting Professor at Princeton's Woodrow Wil
 son School. OpEd contributor at LA Times, USA Today. Usual disclaimers apply","followers_count":43156,"friends_count":4007,"statues_count":84058}}
+{"create_at":datetime("2016-09-23T12:27:12.000"),"id":int64("779401752088940544"),"text":"@tedcruz must NOT endorse Trump! #NeverTrump #HillNo","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("23022687"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"NeverTrump","HillNo"}},"user_mentions":{{23022687}},"place":{"country":"United States","country_code":"United States","full_name":"Oakland Park, FL","id":"b230af2256484995","name":"Oakland Park","place_type":"city","bounding_box":rectangle("-80.196625,26.150489 -80.117027,26.209352")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12011,"countyName":"Broward","cityID":1250575,"cityName":"Oakland Park"},"user":{"id":int64("62919284"),"name":"Tony Gator","screen_name":"gatormiami","lang":"en","location":"MIAMI or thereabouts","create_at":date("2009-08-04"),"description":"Ultra Conservative, Great Gator Fan & Realtor!","followers_count":1724,"friends_count":2385,"stat
 ues_count":23132}}
+{"create_at":datetime("2016-09-23T12:27:19.000"),"id":int64("779401780375543808"),"text":"Kim Kardashian, wife to Kanye West from Chicago, mother of two biracial children.. Is voting Trump. Ha","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Bronx, NY","id":"002e24c6736f069d","name":"Bronx","place_type":"city","bounding_box":rectangle("-73.933612,40.785365 -73.765271,40.91533")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36005,"countyName":"Bronx","cityID":36005,"cityName":"Bronx"},"user":{"id":int64("169662144"),"name":"lani","screen_name":"kailaniskye","lang":"en","location":"Bronx, NY","create_at":date("2010-07-22"),"description":"issa knife.","followers_count":2854,"friends_count":301,"statues_count":40616}}
+{"create_at":datetime("2016-09-23T12:27:19.000"),"id":int64("779401780178321408"),"text":"@OMAROSA I have no intention of \"bowing\" to the bigoted, fascist Trump.. I will STAND, VOTE, FIGHT! https://t.co/jvmb1JC9pu #nevertrump","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("16799621"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"nevertrump"}},"user_mentions":{{16799621}},"place":{"country":"United States","country_code":"United States","full_name":"Glen Burnie, MD","id":"cad757363c1a85df","name":"Glen Burnie","place_type":"city","bounding_box":rectangle("-76.644717,39.131259 -76.563196,39.207912")},"geo_tag":{"stateID":24,"stateName":"Maryland","countyID":24003,"countyName":"Anne Arundel","cityID":2432650,"cityName":"Glen Burnie"},"user":{"id":int64("106288017"),"name":"Kelly Lyles","screen_name":"thekellylyles","lang":"en","location":"Washington, D.C. ","create_at":date("2010-01-18"),"description":"Hybrid Blue Dog 
 Democrat. Tweets on #autos #equality #politics Tweets are my own opinion. RTs are not endorsements.","followers_count":192,"friends_count":790,"statues_count":4109}}
+{"create_at":datetime("2016-09-23T12:27:20.000"),"id":int64("779401782938206209"),"text":"https://t.co/fyLLenVync @Cernovich @LouDobbs @realDonaldTrump","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"user_mentions":{{358545917,26487169,25073877}},"place":{"country":"United States","country_code":"United States","full_name":"Muscle Shoals, AL","id":"74d460734c3eca69","name":"Muscle Shoals","place_type":"city","bounding_box":rectangle("-87.680639,34.705252 -87.617362,34.762527")},"geo_tag":{"stateID":1,"stateName":"Alabama","countyID":1033,"countyName":"Colbert","cityID":153016,"cityName":"Muscle Shoals"},"user":{"id":int64("4852434473"),"name":"GTolbert","screen_name":"GTolbert9","lang":"en","location":"Alabama, USA","create_at":date("2016-01-26"),"description":"null","followers_count":647,"friends_count":559,"statues_count":22532}}
+{"create_at":datetime("2016-09-23T12:27:40.000"),"id":int64("779401869084983296"),"text":"Cincinnati Enquirer spurns Donald Trump to endorse first Democrat in nearly 100 years https://t.co/juhelRdfQX","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Brooklyn, NY","id":"011add077f4d2da3","name":"Brooklyn","place_type":"city","bounding_box":rectangle("-74.041878,40.570842 -73.855673,40.739434")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36047,"countyName":"Kings","cityID":36047,"cityName":"Brooklyn"},"user":{"id":int64("308851637"),"name":"Ingrid E Baptista","screen_name":"Ingridebap","lang":"en","location":"New York","create_at":date("2011-05-31"),"description":"null","followers_count":250,"friends_count":938,"statues_count":15376}}
+{"create_at":datetime("2016-09-23T12:27:44.000"),"id":int64("779401883588833280"),"text":"Uh nope add *sarcasm* pls I don't know you personally and there are too many trump trolls bought by Russia https://t.co/2kStJCm43a","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Las Vegas, NV","id":"5c2b5e46ab891f07","name":"Las Vegas","place_type":"city","bounding_box":rectangle("-115.384091,36.129459 -115.062159,36.336371")},"geo_tag":{"stateID":32,"stateName":"Nevada","countyID":32003,"countyName":"Clark","cityID":3240000,"cityName":"Las Vegas"},"user":{"id":int64("118837027"),"name":"Tracy Downey","screen_name":"msgoddessrises","lang":"en","location":"Viva Las Vegas NV.","create_at":date("2010-03-01"),"description":"Film Student/Writer #DivineInterventionLuckyChronicles CenterR-Ind #Nolabels #NeverTrump #MS #11
 yrs Proud innovator with a keyboard. God is in control.","followers_count":1715,"friends_count":340,"statues_count":157425}}
+{"create_at":datetime("2016-09-23T12:27:45.000"),"id":int64("779401890333196288"),"text":"@OliverNorgrove @LennyPetsPuppys @senatorshoshana @Popehat \nConsidering the crazy ass shit #Trump pulls, Gary looks like a RhodesScholar.","in_reply_to_status":int64("779352824077508608"),"in_reply_to_user":int64("2233524090"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"Trump"}},"user_mentions":{{2233524090,714755712,38445467,18839937}},"place":{"country":"United States","country_code":"United States","full_name":"Eugene, OR","id":"01241e9666cacdd2","name":"Eugene","place_type":"city","bounding_box":rectangle("-123.208615,43.988281 -123.036188,44.142961")},"geo_tag":{"stateID":41,"stateName":"Oregon","countyID":41039,"countyName":"Lane","cityID":4123850,"cityName":"Eugene"},"user":{"id":int64("21906070"),"name":"Remember Benghazi!","screen_name":"Kegan05","lang":"en","location":"Northwest USA","create_at":date("2009-02-25"),"description":
 "Political Junkie, Republican, Recovered Reagan Democrat of 20+ years. Slick Willy was my motivation for dumping the CommieCrats. Never looked back! #TGDN","followers_count":11446,"friends_count":10924,"statues_count":249793}}
+{"create_at":datetime("2016-09-23T12:27:47.000"),"id":int64("779401896033390593"),"text":"To terrible human beings in one picture https://t.co/PhJJsXtcGa","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Auburn, AL","id":"deb349182b3f42bb","name":"Auburn","place_type":"city","bounding_box":rectangle("-85.569969,32.532449 -85.413112,32.662041")},"geo_tag":{"stateID":1,"stateName":"Alabama","countyID":1081,"countyName":"Lee","cityID":103076,"cityName":"Auburn"},"user":{"id":int64("35630380"),"name":"Ben Stoner","screen_name":"Ben_Stoner96","lang":"en","location":"Auburn, AL","create_at":date("2009-04-26"),"description":"AU","followers_count":571,"friends_count":530,"statues_count":14829}}
+{"create_at":datetime("2016-09-23T12:27:47.000"),"id":int64("779401897304289281"),"text":"@guypbenson Cruz is still \u201Cyoung\u201D and ambitious - its probably also not a coincidence this occurring while Trump talking about SCOTUS.","in_reply_to_status":int64("779394688637775873"),"in_reply_to_user":int64("16193222"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{16193222}},"place":{"country":"United States","country_code":"United States","full_name":"Boynton Beach, FL","id":"005e3661711a29a9","name":"Boynton Beach","place_type":"city","bounding_box":rectangle("-80.173447,26.476484 -80.05236,26.590488")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12099,"countyName":"Palm Beach","cityID":1207875,"cityName":"Boynton Beach"},"user":{"id":int64("14641687"),"name":"Aaron Von Gauss","screen_name":"AVonGauss","lang":"en","location":"Boynton Beach, FL","create_at":date("2008-05-03"),"description":"Technology Consultan
 t who strangely does not live in Silicon Valley, Alley nor Wonderland.","followers_count":134,"friends_count":107,"statues_count":8100}}
+{"create_at":datetime("2016-09-23T12:27:52.000"),"id":int64("779401916715376641"),"text":"That says a lot. https://t.co/zKvbTvtmAx","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Shady Shores, TX","id":"6f357cae6be7a645","name":"Shady Shores","place_type":"city","bounding_box":rectangle("-97.065657,33.137751 -97.013767,33.177785")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48121,"countyName":"Denton","cityID":4867100,"cityName":"Shady Shores"},"user":{"id":int64("351153807"),"name":"Nancy Bell","screen_name":"Flygirlfly625","lang":"en","location":"Shady Shores Texas","create_at":date("2011-08-08"),"description":"Occupational Therapist, HomeModification Consultant,NDT Certified. Ergonomic Specialist.Hobbies:Flying, Home Remodeling/Staging, and attempts to play the violin","followers_count":16
 2,"friends_count":435,"statues_count":4024}}
+{"create_at":datetime("2016-09-23T12:27:53.000"),"id":int64("779401920461111297"),"text":"A vote is the ULTIMATE endorsement -After Bitter Primary Fight, Ted Cruz To Back Donald Trump https://t.co/4oFZzi9kGL","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Waverly, MI","id":"00534e655a405438","name":"Waverly","place_type":"city","bounding_box":rectangle("-86.117567,42.783159 -86.058053,42.856213")},"geo_tag":{"stateID":26,"stateName":"Michigan","countyID":26045,"countyName":"Eaton","cityID":2684800,"cityName":"Waverly"},"user":{"id":int64("728972859356250113"),"name":"Murphy for Congress","screen_name":"DMurphyCongress","lang":"en","location":"Grandville, MI","create_at":date("2016-05-07"),"description":"Voters have a choice! I'm Dennis and I hope to serve in Congress as a Dem from Michigan\u2019s 2nd Dis
 trict. Feel free to tweet questions & please vote in November!","followers_count":68,"friends_count":160,"statues_count":87}}
+{"create_at":datetime("2016-09-23T12:27:56.000"),"id":int64("779401933220184064"),"text":"He's not going to endorse. https://t.co/WEh2PwnWB6","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Rosenberg, TX","id":"00f2b6161655c5cc","name":"Rosenberg","place_type":"city","bounding_box":rectangle("-95.835024,29.482424 -95.699766,29.581688")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48157,"countyName":"Fort Bend","cityID":4863284,"cityName":"Rosenberg"},"user":{"id":int64("1424259144"),"name":"Deborah Pearson","screen_name":"debpearsonTX","lang":"en","location":"In the Clouds protecting USA","create_at":date("2013-05-12"),"description":"Born and bred in Texas!! Conservative voter. God fearing, concerned about our REPUBLIC. God bless USA. GOD BLESS TEXAS! #NRA http://tedcruz.org","followers_count":
 2266,"friends_count":3262,"statues_count":18221}}
+{"create_at":datetime("2016-09-23T12:27:56.000"),"id":int64("779401936441315329"),"text":"Imagine thinking this https://t.co/2E79rFHCUo","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Brooklyn, NY","id":"011add077f4d2da3","name":"Brooklyn","place_type":"city","bounding_box":rectangle("-74.041878,40.570842 -73.855673,40.739434")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36047,"countyName":"Kings","cityID":36047,"cityName":"Brooklyn"},"user":{"id":int64("3099901028"),"name":"Brandy Jensen","screen_name":"BrandyLJensen","lang":"en","location":"Brooklyn, NY","create_at":date("2015-03-20"),"description":"behind every successful man is a woman pegging him","followers_count":8538,"friends_count":1446,"statues_count":32937}}
+{"create_at":datetime("2016-09-23T12:27:57.000"),"id":int64("779401938181971969"),"text":"I am a bit puzzled why the same people that harassed Marco about endorsing Trump are making excuses for Cruz now...","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Manlius, NY","id":"a91318fb3d0ef965","name":"Manlius","place_type":"city","bounding_box":rectangle("-76.026142,42.968277 -75.935566,43.093685")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36067,"countyName":"Onondaga","cityID":3645018,"cityName":"Manlius"},"user":{"id":int64("237089251"),"name":"Nick Lindquist","screen_name":"nick_lindquist","lang":"en","location":"Team Marco","create_at":date("2011-01-11"),"description":"LMC '19 \u2022 Marketing \u2022 Young Politico \u2022 @decainc Region 9 Officer/Alum \u2022 John Katko Intern \u2022 Con
 tributor @RedMillennial \u2022 Font Aficionado \u2022 Dr. Pepper Addict","followers_count":934,"friends_count":783,"statues_count":13392}}
+{"create_at":datetime("2016-09-23T12:27:58.000"),"id":int64("779401941575237636"),"text":"They're rl idiots!!!! https://t.co/gdRfntHaXU","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Dale City, VA","id":"66cd2cdb819f4414","name":"Dale City","place_type":"city","bounding_box":rectangle("-77.443065,38.61099 -77.274813,38.68125")},"geo_tag":{"stateID":51,"stateName":"Virginia","countyID":51153,"countyName":"Prince William","cityID":5121088,"cityName":"Dale City"},"user":{"id":int64("3229093668"),"name":"Cheena Byrd","screen_name":"ChillCheena","lang":"en","location":"null","create_at":date("2015-05-28"),"description":"August 25\u2764\uFE0F #E4SooMs","followers_count":420,"friends_count":202,"statues_count":8596}}
+{"create_at":datetime("2016-09-23T12:28:00.000"),"id":int64("779401952438263808"),"text":"@KarenLeslieHall @speechboy71 It's a tossup. This is a dumbed down electorate, fed lies, rumors, rumors of lies daily. Trump is the product.","in_reply_to_status":int64("779371105081516032"),"in_reply_to_user":int64("1169239260"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{1169239260,113061485}},"place":{"country":"United States","country_code":"United States","full_name":"San Francisco, CA","id":"5a110d312052166f","name":"San Francisco","place_type":"city","bounding_box":rectangle("-122.514926,37.708075 -122.357031,37.833238")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6075,"countyName":"San Francisco","cityID":667000,"cityName":"San Francisco"},"user":{"id":int64("977619834"),"name":"Blind Willies","screen_name":"williesband","lang":"en","location":"San Francisco","create_at":date("2012-11-28"),"description":"rock. \
 r\n\r\nStreaming: http://blindwillies.bandcamp.com\r\n\r\nhttp://facebook.com/blindwillies\r\n\r\nContact: blindwillies@blindwillies.net","followers_count":1156,"friends_count":952,"statues_count":6176}}
+{"create_at":datetime("2016-09-23T12:28:09.000"),"id":int64("779401988949811200"),"text":"@AlanColmes You are constantly looking ways to bash Trump? Open your eyes Allen and see what HRC has to offer. Nada. You do us a disservice","in_reply_to_status":int64("779393945889411072"),"in_reply_to_user":int64("14924233"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{14924233}},"place":{"country":"United States","country_code":"United States","full_name":"Huntertown, IN","id":"017e230d04270300","name":"Huntertown","place_type":"city","bounding_box":rectangle("-85.186546,41.199635 -85.104621,41.244575")},"geo_tag":{"stateID":18,"stateName":"Indiana","countyID":18003,"countyName":"Allen","cityID":1835266,"cityName":"Huntertown"},"user":{"id":int64("321627407"),"name":"Jeanne Boutilier","screen_name":"mtnest11","lang":"en","location":"Indiana, USA","create_at":date("2011-06-21"),"description":"Happy follower of spouse, 6 states / 11 ho
 uses. Love being a Grams, best job ever! Lover of life, family, friends & all breathing things. (except spiders)","followers_count":180,"friends_count":297,"statues_count":4288}}
+{"create_at":datetime("2016-09-23T12:28:11.000"),"id":int64("779401997527031808"),"text":"This newspaper just endorsed its first Democrat for president in almost a century, because Trump https://t.co/Wuudp4zhf1 via @motherjones","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{18510860}},"place":{"country":"United States","country_code":"United States","full_name":"Dublin, CA","id":"003253f0107acd32","name":"Dublin","place_type":"city","bounding_box":rectangle("-121.979522,37.697406 -121.849535,37.733656")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6001,"countyName":"Alameda","cityID":620018,"cityName":"Dublin"},"user":{"id":int64("1850731"),"name":"Joyce Tompsett","screen_name":"joycetompsett","lang":"en","location":"Nerdistan CA","create_at":date("2007-03-22"),"description":"Girl Geek, Tech Evangelist, Dir. of Silicon Valley Exec Briefing Ctr at D
 ell Technologies, yogini, world traveler, living moment by moment w/open heart.","followers_count":902,"friends_count":1335,"statues_count":9773}}
+{"create_at":datetime("2016-09-23T12:28:12.000"),"id":int64("779401999859064832"),"text":"\uD83D\uDE04 https://t.co/pE1oMWDVjL","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Summerlin South, NV","id":"0134e6167ff7f6ec","name":"Summerlin South","place_type":"city","bounding_box":rectangle("-115.355825,36.082837 -115.314862,36.159081")},"geo_tag":{"stateID":32,"stateName":"Nevada","countyID":32003,"countyName":"Clark","cityID":3270900,"cityName":"Summerlin South"},"user":{"id":int64("50230100"),"name":"Tracey","screen_name":"tsh219","lang":"en","location":"Las Vegas,NV ","create_at":date("2009-06-23"),"description":"Native New Yorker, Educator, Doctoral (Ed.D.) Candidate. Waiting For My White Privilege To Kick In. #TrumpPence2016 #MAGA #NeverHillary","followers_count":766,"friends_count":522,"statues_cou
 nt":5386}}


Mime
View raw message