You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by im...@apache.org on 2016/10/06 05:38:19 UTC
[1/3] asterixdb git commit: Tests for ASTERIXDB-1636
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}}
[3/3] asterixdb git commit: Tests for ASTERIXDB-1636
Posted by im...@apache.org.
Tests for ASTERIXDB-1636
This is a test for the scenario described in the Jira issue. The only
thing I have taken liberty with is changing the socket feed to a file
one. The test case fails when I revert AqlMetadataProvider to the
previous version, and should pass now with this parent.
Change-Id: Ic1521f1d53121b67677778ac123e49e731932c85
Reviewed-on: https://asterix-gerrit.ics.uci.edu/1248
Sonar-Qube: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Taewoo Kim <wa...@yahoo.com>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo
Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/ecba52e0
Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/ecba52e0
Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/ecba52e0
Branch: refs/heads/master
Commit: ecba52e0b9eca4f59b9b7fc082b720d677b4d98d
Parents: 0309d51
Author: Ian Maxon <im...@apache.org>
Authored: Wed Oct 5 17:56:07 2016 -0700
Committer: Ian Maxon <im...@apache.org>
Committed: Wed Oct 5 22:17:08 2016 -0700
----------------------------------------------------------------------
.../installer/test/AsterixRestartIT.java | 102 +++++++++++++++++++
.../resources/integrationts/restart/828.h1w.adm | 100 ++++++++++++++++++
.../issue-1636/issue-1636.01.ddl.aql | 81 +++++++++++++++
.../issue-1636/issue-1636.02.ddl.aql | 27 +++++
.../issue-1636/issue-1636.03.script.aql | 1 +
.../issue-1636/issue-1636.04.ddl.aql | 35 +++++++
.../issue-1636/issue-1636.05.mgx.aql | 2 +
.../issue-1636/issue-1636.06.mgx.aql | 2 +
.../issue-1636/issue-1636.07.script.aql | 1 +
.../issue-1636/issue-1636.08.ddl.aql | 27 +++++
.../issue-1636/issue-1636.09.sleep.aql | 25 +++++
.../issue-1636/issue-1636.10.script.aql | 1 +
.../issue-1636/issue-1636.11.script.aql | 1 +
.../scripts/feed-restart/issue-1636/cat.sh | 18 ++++
.../scripts/feed-restart/issue-1636/grep_log.sh | 20 ++++
.../feed-restart/issue-1636/kill_cc_and_nc.sh | 18 ++++
.../scripts/feed-restart/issue-1636/touch.sh | 21 ++++
.../integrationts/restart/testsuite.xml | 28 +++++
.../resources/integrationts/restart/tweets.json | 39 +++++++
19 files changed, 549 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/java/org/apache/asterix/installer/test/AsterixRestartIT.java
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/java/org/apache/asterix/installer/test/AsterixRestartIT.java b/asterixdb/asterix-installer/src/test/java/org/apache/asterix/installer/test/AsterixRestartIT.java
new file mode 100644
index 0000000..6d7eaa4
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/java/org/apache/asterix/installer/test/AsterixRestartIT.java
@@ -0,0 +1,102 @@
+/*
+ * 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.
+ */
+package org.apache.asterix.installer.test;
+
+import java.io.File;
+import java.util.List;
+import java.util.Map;
+import java.util.logging.Logger;
+
+import org.apache.asterix.event.model.AsterixInstance.State;
+import org.apache.asterix.test.aql.TestExecutor;
+import org.apache.asterix.test.base.RetainLogsRule;
+import org.apache.asterix.testframework.context.TestCaseContext;
+import org.apache.commons.lang3.StringUtils;
+import org.junit.AfterClass;
+import org.junit.BeforeClass;
+import org.junit.Rule;
+import org.junit.Test;
+import org.junit.rules.TestRule;
+
+//This is just a simple derivative of all of the other IT test cases specifically for test cases which revolve around
+//some behavior where stopping and starting Asterix causes issues
+public class AsterixRestartIT {
+
+ private static final String PATH_BASE = "src/test/resources/integrationts/restart/";
+ private static final String PATH_ACTUAL = "target" + File.separator + "ittest" + File.separator;
+ private static final Logger LOGGER = Logger.getLogger(AsterixRestartIT.class.getName());
+ private static List<TestCaseContext> testCaseCollection;
+ private static String reportPath = new File(
+ StringUtils.join(new String[] { "target", "failsafe-reports" }, File.separator)).getAbsolutePath();
+
+ private final TestExecutor testExecutor = new TestExecutor();
+ private static String scriptHomePath;
+ private static File asterixInstallerPath;
+ private static ProcessBuilder pb;
+ private static Map<String, String> env;
+
+ @Rule
+ public TestRule retainLogs = new RetainLogsRule(AsterixInstallerIntegrationUtil.getManagixHome(), reportPath);
+
+ @BeforeClass
+ public static void setUp() throws Exception {
+ try {
+ pb = new ProcessBuilder();
+ env = pb.environment();
+ asterixInstallerPath = new File(System.getProperty("user.dir"));
+ scriptHomePath = asterixInstallerPath + File.separator + "src" + File.separator + "test" + File.separator
+ + "resources" + File.separator + "integrationts" + File.separator + "restart"
+ + File.separator + "scripts";
+ env.put("SCRIPT_HOME", scriptHomePath);
+ AsterixInstallerIntegrationUtil.init();
+ AsterixInstallerIntegrationUtil.transformIntoRequiredState(State.ACTIVE);
+ TestCaseContext.Builder b = new TestCaseContext.Builder();
+ testCaseCollection = b.build(new File(PATH_BASE));
+ } catch (Throwable th) {
+ th.printStackTrace();
+ throw th;
+ }
+ }
+
+ @AfterClass
+ public static void tearDown() throws Exception {
+ AsterixInstallerIntegrationUtil.deinit();
+ }
+
+ @Test
+ public void test() throws Exception {
+ for (TestCaseContext testCaseCtx : testCaseCollection) {
+ testExecutor.executeTest(PATH_ACTUAL, testCaseCtx, pb, false);
+ }
+
+ }
+
+ public static void main(String[] args) throws Exception {
+ try {
+ setUp();
+ new AsterixRestartIT().test();
+ } catch (Exception e) {
+ e.printStackTrace();
+ LOGGER.info("TEST CASES FAILED");
+ } finally {
+ tearDown();
+ }
+ }
+
+}
[2/3] asterixdb git commit: Tests for ASTERIXDB-1636
Posted by im...@apache.org.
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/828.h1w.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/828.h1w.adm b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/828.h1w.adm
new file mode 100644
index 0000000..1664fa9
--- /dev/null
+++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/828.h1w.adm
@@ -0,0 +1,100 @@
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929038727086081"),"text":"My nephew just made my day https://t.co/ZG16634ckU","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":{"id":int64("532607253"),"name":"Alonzo","screen_name":"ZoDiamond777","lang":"en","location":"MIA,FLA 777","create_at":date("2012-03-21"),"description":"JOKER","followers_count":685,"friends_count":653,"statues_count":33064},"place":{"country":"United States","country_code":"United States","full_name":"Kendall, FL","id":"9b46dccb3cfb880c","name":"Kendall","place_type":"city","bounding_box":rectangle("-80.389344,25.628844 -80.304896,25.715128")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12086,"countyName":"Miami-Dade","cityID":1236100,"cityName":"Kendall"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929038852943872"),"text":"Boat ride!! \uD83D\uDEE5 on the river (@ Corporate Tailgate Boat Rentals in Chicago, IL) https://t.co/cb3KfMYlVS","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":{"id":int64("2871341"),"name":"Sharon H.","screen_name":"ReadingChick","lang":"en","location":"The Western Suburbs","create_at":date("2007-03-29"),"description":"Children's Librarians Grow Life Long Learners. More affable than rumor would have it. Happily married to Hubba Hubba.","followers_count":997,"friends_count":777,"statues_count":21876},"place":{"country":"United States","country_code":"United States","full_name":"Chicago, IL","id":"1d9a5370a355ab0c","name":"Chicago","place_type":"city","bounding_box":rectangle("-87.940033,41.644102 -87.523993,42.023067")},"coordinate":point("-87.6574459,41.90307574"),"geo_tag":{"stateID"
:17,"stateName":"Illinois","countyID":17031,"countyName":"Cook","cityID":1714000,"cityName":"Chicago"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929039272300544"),"text":"#ThisWeek the #CLITERATI demo was released. Check it out #PortlandPunx #DIY #hardcore #crust #dbeat https://t.co/uclG4Mi1kx","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":{{"ThisWeek","CLITERATI","PortlandPunx","DIY","hardcore","crust","dbeat"}},"user":{"id":int64("417393117"),"name":"Ami Lawless","screen_name":"AmiLawless","lang":"en","location":"San Fran & Portlandia","create_at":date("2011-11-20"),"description":"SF Weekly's Best DJ 2014. former punk/metal DJ @ RadioValencia,columnist for a few zines,vox Cliterati/VOETSEK/Bedrucken/Dairy Queens","followers_count":2322,"friends_count":3060,"statues_count":7218},"place":{"country":"United States","country_code":"United States","full_name":"Portland, OR","id":"ac88a4f17a51c7fc","name":"Portland","place_type":"city","bounding_box":re
ctangle("-122.790065,45.421863 -122.471751,45.650941")},"geo_tag":{"stateID":41,"stateName":"Oregon","countyID":41051,"countyName":"Multnomah","cityID":4159000,"cityName":"Portland"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929038798397440"),"text":"\uD83D\uDE02\uD83D\uDE2D https://t.co/bwpyV7dHXi","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":{"id":int64("402413445"),"name":"Keyur Patel \u3072","screen_name":"kpatel_6","lang":"en","location":"null","create_at":date("2011-10-31"),"description":"SJJ '18 Snapchat: Silver908","followers_count":161,"friends_count":155,"statues_count":5734},"place":{"country":"United States","country_code":"United States","full_name":"Toledo, OH","id":"7068dd9474ab6973","name":"Toledo","place_type":"city","bounding_box":rectangle("-83.694776,41.580375 -83.454566,41.732806")},"geo_tag":{"stateID":39,"stateName":"Ohio","countyID":39095,"countyName":"Lucas","cityID":3977000,"cityName":"Toledo"}}
+{"create_at":datetime("2016-08-28T09:06:01.000"),"id":int64("769929038341242880"),"text":"life's a beach\n#huntingtonbeach @ Huntington Beach, California https://t.co/csJVJp8Swh","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":{{"huntingtonbeach"}},"user":{"id":int64("710094718256844801"),"name":"Geny","screen_name":"itsgenyc","lang":"en","location":"Dallas, TX","create_at":date("2016-03-16"),"description":"expert when it comes to being awkward","followers_count":59,"friends_count":135,"statues_count":242},"place":{"country":"United States","country_code":"United States","full_name":"Huntington Beach, CA","id":"80eb17ffe368fc9a","name":"Huntington Beach","place_type":"city","bounding_box":rectangle("-118.082615,33.628991 -117.91485,33.756093")},"coordinate":point("-118.0,33.6929"),"geo_tag":{"stateID":6,"stateName":"California","countyID":6059,"countyName":"Orange","cityI
D":636000,"cityName":"Huntington Beach"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929039448506368"),"text":"Biking to the vineyard city style. #nyc #vineyard #hudson #winetime #sunday #sundayfunday @ City\u2026 https://t.co/qZzVi7n2vD","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":{{"nyc","vineyard","hudson","winetime","sunday","sundayfunday"}},"user":{"id":int64("18413391"),"name":"Shelly Lipton","screen_name":"ShellyLipton","lang":"en","location":"new york city","create_at":date("2008-12-27"),"description":"digital marketer, advisor, business developer, toy recycler, biking fanatic, art junkie, wine lover, head of marketing @Roomiapp","followers_count":2372,"friends_count":1561,"statues_count":6137},"place":{"country":"United States","country_code":"United States","full_name":"Manhattan, NY","id":"01a9a39529b27f36","name":"Manhattan","place_type":"city","bounding_box":rectangle("-74.02
6675,40.683935 -73.910408,40.877483")},"coordinate":point("-74.0119355,40.7199192"),"geo_tag":{"stateID":36,"stateName":"New York","countyID":36061,"countyName":"New York","cityID":36061,"cityName":"Manhattan"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929039633014784"),"text":"Everyday \uD83D\uDC94 https://t.co/oNPuRMwgM6","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":{"id":int64("2209170043"),"name":"Queen Double DD","screen_name":"QueenDoubleDD","lang":"en","location":"Texas.\u2741","create_at":date("2013-11-22"),"description":"18 \u2022sc: si-drill \u2022My hearts become to cold to break \u2022 UST Volleyball","followers_count":1151,"friends_count":1271,"statues_count":6535},"place":{"country":"United States","country_code":"United States","full_name":"Houston, TX","id":"1c69a67ad480e1b1","name":"Houston","place_type":"city","bounding_box":rectangle("-95.823268,29.522325 -95.069705,30.154665")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48201,"countyName":"Harris","cityID":4835000,"cityName":"Houston"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929039683260416"),"text":"It takes \"guts and integrity\" to parrot the Leftist echo chamber https://t.co/9qefvaPxMy","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":{"id":int64("51599151"),"name":"Nisley the White","screen_name":"SonOfMokeHill","lang":"en","location":"Post-American Hellhole, NV","create_at":date("2009-06-27"),"description":"The Left seeks to ban Christianity and Free Speech. Anyone who proclaims an allegiance to either but fails to back Trump is the Left's ally.","followers_count":194,"friends_count":180,"statues_count":10172},"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"}}
+{"create_at":datetime("2016-08-28T09:06:01.000"),"id":int64("769929037821075456"),"text":"when walking through school https://t.co/3YDKVgzLcF","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":{"id":int64("1271362543"),"name":"Briley Bodin \u2661","screen_name":"BrileyBodin17","lang":"en","location":"Nashville, TN","create_at":date("2013-03-15"),"description":"null","followers_count":1039,"friends_count":765,"statues_count":2524},"place":{"country":"United States","country_code":"United States","full_name":"Brentwood, TN","id":"42835dec78de1327","name":"Brentwood","place_type":"city","bounding_box":rectangle("-86.869446,35.939893 -86.686525,36.05065")},"geo_tag":{"stateID":47,"stateName":"Tennessee","countyID":47187,"countyName":"Williamson","cityID":4708280,"cityName":"Brentwood"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929039943467009"),"text":"@rgj I'm a New York Giants fan and I support this 49er quarterback why should we support a ountry that don't support us.#blacklivesmatter","in_reply_to_status":int64("769922393481412608"),"in_reply_to_user":int64("9690012"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"blacklivesmatter"}},"user_mentions":{{9690012}},"user":{"id":int64("441431532"),"name":"Ken E,Williams jr","screen_name":"nygiant150","lang":"en","location":" Bethlehem PA","create_at":date("2011-12-19"),"description":"I love classical and Celtic music I also love to learn and experience new things and I'm a big fan of women comedians","followers_count":1192,"friends_count":3120,"statues_count":8413},"place":{"country":"United States","country_code":"United States","full_name":"Bethlehem, PA","id":"128ae72e3854b273","name":"Bethlehem","place_type":"city","bounding_box":rectang
le("-75.4314,40.578043 -75.302993,40.672508")},"geo_tag":{"stateID":42,"stateName":"Pennsylvania","countyID":42095,"countyName":"Northampton","cityID":4206088,"cityName":"Bethlehem"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929039998021632"),"text":"Day 1 #AfroPunkBK2016 #AfroPunk #BigHairDontCare #Fringe #Melanin #NaturalHair #Aztec #Nike @\u2026 https://t.co/QhAyfTnSdi","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":{{"AfroPunkBK2016","AfroPunk","BigHairDontCare","Fringe","Melanin","NaturalHair","Aztec","Nike"}},"user":{"id":int64("106653718"),"name":"Asia K","screen_name":"ZingItsAsiaK","lang":"en","location":"Cincinnati\u21E8Chicago","create_at":date("2010-01-19"),"description":"Freckle faced chick with that Zing! \nActress|Singer|Songwritter. \nMy EP #TheZingRoom Coming Soon.","followers_count":519,"friends_count":319,"statues_count":15440},"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")},"coordinate":point("-73.95,40.65"),"geo_tag":{"stateID":36,"stateName":"New York","countyID":36047,"countyName":"Kings","cityID":36047,"cityName":"Brooklyn"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929040241143808"),"text":"\uD83D\uDC40\uD83D\uDE48 https://t.co/jnByCgyRgF","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":{"id":int64("2907351446"),"name":"Michael Houston","screen_name":"TheHeadhunter31","lang":"en","location":"null","create_at":date("2014-11-22"),"description":"If they hate, they watchin, if they watchin, they jus apart of the fan club, let em hate #31 #WBU","followers_count":426,"friends_count":520,"statues_count":1584},"place":{"country":"United States","country_code":"United States","full_name":"Lubbock, TX","id":"3f3f6803f117606d","name":"Lubbock","place_type":"city","bounding_box":rectangle("-102.033765,33.44712 -101.760581,33.693933")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48303,"countyName":"Lubbock","cityID":4845000,"cityName":"Lubbock"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929040299958272"),"text":"@MichaelHewitt23 @Amtrak @GovGaryJohnson @SpaceX competition is necessary for our citizens","in_reply_to_status":int64("769891257858465792"),"in_reply_to_user":int64("409501734"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{409501734,119166791,95713333,34743251}},"user":{"id":int64("21556912"),"name":"Michael Fabiano","screen_name":"MichaelFabiano","lang":"en","location":"NYC, SF, London, Paris","create_at":date("2009-02-22"),"description":"Pilot, Car Nut, Yankees-aholic, Interested in tech, Proud American, Tenor.","followers_count":4195,"friends_count":1765,"statues_count":4683},"place":{"country":"United States","country_code":"United States","full_name":"Philadelphia, PA","id":"e4a0d228eb6be76b","name":"Philadelphia","place_type":"city","bounding_box":rectangle("-75.280284,39.871811 -74.955712,40.13792")},"geo_tag":{"stateID":42,"sta
teName":"Pennsylvania","countyID":42101,"countyName":"Philadelphia","cityID":4260000,"cityName":"Philadelphia"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929040958332928"),"text":"I pull up on you then I pop at your kid","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":{"id":int64("2463887766"),"name":"Brett Favre","screen_name":"_R_D_B","lang":"en","location":"the trap","create_at":date("2014-04-25"),"description":"I am running for president in 2033","followers_count":113,"friends_count":113,"statues_count":1741},"place":{"country":"United States","country_code":"United States","full_name":"Deerfield Beach, FL","id":"4ebdbc556ccd2f12","name":"Deerfield Beach","place_type":"city","bounding_box":rectangle("-80.170343,26.274467 -80.074368,26.327929")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12011,"countyName":"Broward","cityID":1216725,"cityName":"Deerfield Beach"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929040874668032"),"text":"Twitter https://t.co/GdyFgLlK8A","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":{"id":int64("755831881946497024"),"name":"kingK\u00AE","screen_name":"_kaniyac","lang":"en","location":"WithyourMCM","create_at":date("2016-07-20"),"description":"AMOSC:kaniyac \u2728 810\u2708251 C/o 2017","followers_count":180,"friends_count":248,"statues_count":4984},"place":{"country":"United States","country_code":"United States","full_name":"Mobile, AL","id":"d049033410e9e81b","name":"Mobile","place_type":"city","bounding_box":rectangle("-88.301598,30.523874 -88.021513,30.843424")},"geo_tag":{"stateID":1,"stateName":"Alabama","countyID":1097,"countyName":"Mobile","cityID":150000,"cityName":"Mobile"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929041893666816"),"text":"@lillipoop ya bae it a lil day trip","in_reply_to_status":int64("769928937241767936"),"in_reply_to_user":int64("2452391970"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{2452391970}},"user":{"id":int64("368394931"),"name":"yardley yeti","screen_name":"Ktmilllz","lang":"en","location":"Yardl","create_at":date("2011-09-05"),"description":"I love Jesus but I drink a little","followers_count":406,"friends_count":445,"statues_count":14211},"place":{"country":"United States","country_code":"United States","full_name":"Philadelphia, PA","id":"e4a0d228eb6be76b","name":"Philadelphia","place_type":"city","bounding_box":rectangle("-75.280284,39.871811 -74.955712,40.13792")},"geo_tag":{"stateID":42,"stateName":"Pennsylvania","countyID":42101,"countyName":"Philadelphia","cityID":4260000,"cityName":"Philadelphia"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929042120368128"),"text":"Finally getting around to packing up my room today","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":{"id":int64("3030534190"),"name":"ekoorb","screen_name":"brookeblxckwell","lang":"en","location":"DET~CHI","create_at":date("2015-02-11"),"description":"\u2728the truth is out there\u2728 \uD83D\uDC7B:earthtobroooke \uD83D\uDCF7:brookeblxckwell","followers_count":206,"friends_count":169,"statues_count":2214},"place":{"country":"United States","country_code":"United States","full_name":"Roseville, MI","id":"7b082d03ee1b544d","name":"Roseville","place_type":"city","bounding_box":rectangle("-82.968959,42.479787 -82.902872,42.539749")},"geo_tag":{"stateID":26,"stateName":"Michigan","countyID":26099,"countyName":"Macomb","cityID":2669800,"cityName":"Roseville"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929041990279172"),"text":"@berskeezz 1st floor Jacobs! 103","in_reply_to_status":int64("769928796594135040"),"in_reply_to_user":int64("2344315182"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{2344315182}},"user":{"id":int64("220887418"),"name":"Katie Nageotte","screen_name":"ktnago13","lang":"en","location":"OFalls/Ashland/Kville","create_at":date("2010-11-28"),"description":"I like to ride poles on occasion. #adidas #TeamPacer #pickybars. Set your goals to experience your dreams, and your life will be truly extraordinary.","followers_count":1718,"friends_count":522,"statues_count":9589},"place":{"country":"United States","country_code":"United States","full_name":"Ashland, OH","id":"fefd06f07572907a","name":"Ashland","place_type":"city","bounding_box":rectangle("-82.352896,40.835537 -82.275563,40.893194")},"geo_tag":{"stateID":39,"stateName":"Ohio","countyID":
39005,"countyName":"Ashland","cityID":3902568,"cityName":"Ashland"}}
+{"create_at":datetime("2016-08-28T09:06:02.000"),"id":int64("769929042514550785"),"text":"Trump has been a model citizen for years generosity &giving jobs even in movies respected &still ppl r jealous Trump wins Presidency\uD83C\uDDFA\uD83C\uDDF8\uD83C\uDF89","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":{"id":int64("4872762849"),"name":"JoAnn","screen_name":"JoAnn82236460","lang":"en","location":"Pennsylvania, USA","create_at":date("2016-02-02"),"description":"I Bleed red white&Blue \u2764\uFE0F\u271DCertified Nurse Aide Daughter of Marine w 2 sons\u2764\uFE0FMe some Trump","followers_count":313,"friends_count":167,"statues_count":4462},"place":{"country":"United States","country_code":"United States","full_name":"Lawnton, PA","id":"cfa6b7cbdb3c503c","name":"Lawnton","place_type":"city","bounding_box":rectangle("-76.813992,40.254739 -76.778085,40.273166")},"geo_tag":{"stat
eID":42,"stateName":"Pennsylvania","countyID":42043,"countyName":"Dauphin","cityID":4241944,"cityName":"Lawnton"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929042858430464"),"text":"@becccamichele @courtdoz17 come snuggle with me","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("343115245"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{343115245,1613990726}},"user":{"id":int64("513609590"),"name":"Holly Brewer\u2764\uFE0F","screen_name":"Hollypop1717","lang":"en","location":"cypress // huntsville","create_at":date("2012-03-03"),"description":"Instagram @holly_brewer17 ~ SHSU '18 @classicb2016","followers_count":645,"friends_count":765,"statues_count":5143},"place":{"country":"United States","country_code":"United States","full_name":"Huntsville, TX","id":"85d3434ace478e35","name":"Huntsville","place_type":"city","bounding_box":rectangle("-95.600652,30.643296 -95.493887,30.768881")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48471,"countyName":"Walker","cityID":4835528,"cityName":"Huntsville"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929042686451712"),"text":"loooook @JordanHanz!! you're AMAZING \u2728 https://t.co/JsKDz8415b","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":{{1878020600}},"user":{"id":int64("156829213"),"name":"\u1D0B\u026A\u1D1B\u1D1B\u028F","screen_name":"VeeSikk","lang":"en","location":"ig & sc - veesikk","create_at":date("2010-06-17"),"description":"\u2022 horngry","followers_count":2151,"friends_count":245,"statues_count":37762},"place":{"country":"United States","country_code":"United States","full_name":"Bakersfield, CA","id":"960993b9cfdffda9","name":"Bakersfield","place_type":"city","bounding_box":rectangle("-119.172179,35.255821 -118.878147,35.437982")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6029,"countyName":"Kern","cityID":603526,"cityName":"Bakersfield"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929043172954113"),"text":"@baileythebutt guess I'm goin in after work!!!","in_reply_to_status":int64("769928967608348676"),"in_reply_to_user":int64("126525007"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{126525007}},"user":{"id":int64("126525007"),"name":"witch \u26B0 pussy","screen_name":"baileythebutt","lang":"en","location":"Kissass City, MO","create_at":date("2010-03-25"),"description":"a hot and sweaty midwestern mess. industrial prostitute. \u2692\u26D3they/them she/her and sometimes he/him","followers_count":360,"friends_count":224,"statues_count":17345},"place":{"country":"United States","country_code":"United States","full_name":"Kansas City, MO","id":"9a974dfc8efb32a0","name":"Kansas City","place_type":"city","bounding_box":rectangle("-94.733122,38.868002 -94.385441,39.332095")},"geo_tag":{"stateID":29,"stateName":"Missouri","countyID":29095,"countyN
ame":"Jackson","cityID":2938000,"cityName":"Kansas City"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929042992791555"),"text":"\uD83D\uDE0D https://t.co/tZL2Li81ha","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":{"id":int64("1728388064"),"name":"future icon \u2728","screen_name":"0fficial_j0sh","lang":"en","location":"atl ","create_at":date("2013-09-04"),"description":"90sjunkie, socially aware. janet and ariana enthusiast. music fanatic. I tweet a lot.","followers_count":814,"friends_count":613,"statues_count":34271},"place":{"country":"United States","country_code":"United States","full_name":"Redan, GA","id":"b39bbbbd69b97fc0","name":"Redan","place_type":"city","bounding_box":rectangle("-84.197462,33.714249 -84.115297,33.761826")},"geo_tag":{"stateID":13,"stateName":"Georgia","countyID":13089,"countyName":"DeKalb","cityID":1363952,"cityName":"Redan"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929043386830848"),"text":"Lol let's try this again @ Strawberry Fields https://t.co/gDamSNlExk","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":{"id":int64("720476509"),"name":"Hannah Kahn","screen_name":"H_Kizzzle","lang":"en","location":"null","create_at":date("2012-07-27"),"description":"I drive a Camry and go to Disney -- too nitt to quit PSU 2019","followers_count":489,"friends_count":323,"statues_count":16180},"place":{"country":"United States","country_code":"United States","full_name":"State College, PA","id":"22c613c36f32f0d1","name":"State College","place_type":"city","bounding_box":rectangle("-77.917295,40.749326 -77.798924,40.817749")},"coordinate":point("-77.847069,40.785414"),"geo_tag":{"stateID":42,"stateName":"Pennsylvania","countyID":42027,"countyName":"Centre","cityID":4273808,"cityName":"State
College"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929043932086273"),"text":".@Strava can you please support emoji for activity titles. Thanks! \uD83D\uDE01\uD83C\uDFC3\uD83D\uDEB4","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":{{42924530}},"user":{"id":int64("105062323"),"name":"Colin Gardiner","screen_name":"ColinGardiner","lang":"en","location":"San Francisco","create_at":date("2010-01-14"),"description":"VP of Product/Analytics @Tripping, avid ultra-marathoner, beer/coffee drinker and tireless optimizer of online products. Love me some monetization!","followers_count":376,"friends_count":1043,"statues_count":2323},"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"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929043802148864"),"text":"girl i was sleep https://t.co/vdmF1iP6ny","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":{"id":int64("3302842837"),"name":"September 13th\u264D\uFE0F","screen_name":"kaaayla_09","lang":"en","location":"somewhere probably sleep","create_at":date("2015-07-31"),"description":"| sc: kayla91300 | all i need in this life of sin , is my very bestfriend , @woahnijah \u2764\uFE0F","followers_count":462,"friends_count":528,"statues_count":10816},"place":{"country":"United States","country_code":"United States","full_name":"Arlington, TX","id":"6e315e1f96e0450a","name":"Arlington","place_type":"city","bounding_box":rectangle("-97.233811,32.586565 -97.037464,32.817135")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48439,"countyName":"Tarrant","cityID":4804000,"cityName":"Arlington"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929043789619200"),"text":"@positiveimagep @MyBlackMatters https://t.co/SgBudwcGvW","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("514692295"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"user_mentions":{{514692295,436721105}},"user":{"id":int64("2811707723"),"name":"Tanya J Ajala","screen_name":"AjalaTanya","lang":"en","location":"Mother Africa","create_at":date("2014-10-06"),"description":"Obama Girl, Keepin It Real, Thinker","followers_count":849,"friends_count":1975,"statues_count":19078},"place":{"country":"United States","country_code":"United States","full_name":"Staten Island, NY","id":"00c55f041e27dc51","name":"Staten Island","place_type":"city","bounding_box":rectangle("-74.255641,40.495865 -74.052253,40.648887")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36085,"countyName":"Richmond","cityID":36085,"cityName":"Staten Island"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044032970754"),"text":"Thank god my boy Miguel didn't have to have surgery so he should have a speedy recovery and my boy Seth \uD83D\uDE4F\uD83C\uDFFE","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":{"id":int64("541516851"),"name":"\u26A1\uFE0F\u00A1\u00B0O Ducks\u00B0\u00A1\u26A1\uFE0F","screen_name":"JayKing561","lang":"en","location":"Eugene Oregon","create_at":date("2012-03-31"),"description":"God,Family and Oregon \u270A ! #RipCT&SD #WTD #GoDucks #GoEagles #OKC #Cavs #ChiefsKingdom","followers_count":972,"friends_count":819,"statues_count":71010},"place":{"country":"United States","country_code":"United States","full_name":"Palm Bay, FL","id":"9979d3480f2d1e45","name":"Palm Bay","place_type":"city","bounding_box":rectangle("-80.737408,27.910056 -80.566228,28.063838")},"geo_tag":{"stateID":12,"stateName"
:"Florida","countyID":12009,"countyName":"Brevard","cityID":1254000,"cityName":"Palm Bay"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044276109313"),"text":"@eldiablito_72 oh for sure. & it's about obsession. Fincher who is obsessive & meticulous when making a film. It's wonderful","in_reply_to_status":int64("769927309876867073"),"in_reply_to_user":int64("15103682"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{15103682}},"user":{"id":int64("357628677"),"name":"Collin Llewellyn","screen_name":"collinllewellyn","lang":"en","location":"Los Angeles, CA","create_at":date("2011-08-18"),"description":"Writer. #MovieADay list:https://docs.google.com/document/d/1Gx6nAmM1iIiExx36SRegoAW7-4EJfy3BtQIvikosmrY/edit","followers_count":376,"friends_count":395,"statues_count":15437},"place":{"country":"United States","country_code":"United States","full_name":"Los Angeles, CA","id":"3b77caf94bfc81fe","name":"Los Angeles","place_type":"city","bounding_box":rectangle("-118.668404,33.704538 -118.155409,34.3370
41")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6037,"countyName":"Los Angeles","cityID":644000,"cityName":"Los Angeles"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044603174914"),"text":"so happy babe came to visit me \u2764\uFE0F\uD83D\uDC97","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":{"id":int64("1384603092"),"name":"aaliyah reyes \u2661","screen_name":"aaliyahreyes_9","lang":"en","location":"WSU","create_at":date("2013-04-27"),"description":"| 8.29.12 \u2661 |","followers_count":756,"friends_count":594,"statues_count":8002},"place":{"country":"United States","country_code":"United States","full_name":"Wichita, KS","id":"1661ada9b2b18024","name":"Wichita","place_type":"city","bounding_box":rectangle("-97.534906,37.562483 -97.152924,37.80531")},"geo_tag":{"stateID":20,"stateName":"Kansas","countyID":20173,"countyName":"Sedgwick","cityID":2079000,"cityName":"Wichita"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044431409156"),"text":"I love u more than I love college. @ Florence, Alabama https://t.co/Ffujgcg5Jj","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":{"id":int64("339492609"),"name":"lucifer \u2661","screen_name":"maiamarae","lang":"en","location":"finding myself","create_at":date("2011-07-20"),"description":"18. I ain't shit yea, I know.","followers_count":1483,"friends_count":567,"statues_count":29040},"place":{"country":"United States","country_code":"United States","full_name":"Florence, AL","id":"7ae765412ef88940","name":"Florence","place_type":"city","bounding_box":rectangle("-87.721811,34.77898 -87.580289,34.8896")},"coordinate":point("-87.6629,34.8203"),"geo_tag":{"stateID":1,"stateName":"Alabama","countyID":1077,"countyName":"Lauderdale","cityID":126896,"cityName":"Florence"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044251074561"),"text":"@erich_irwin I'll come to Fairfield whenever I please","in_reply_to_status":int64("769928956267073536"),"in_reply_to_user":int64("2579319880"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{2579319880}},"user":{"id":int64("2632520573"),"name":"Michael Masuck","screen_name":"mike_masuck7","lang":"en","location":"X '18","create_at":date("2014-06-22"),"description":"When in trouble, tuck for double","followers_count":188,"friends_count":198,"statues_count":930},"place":{"country":"United States","country_code":"United States","full_name":"White Oak, OH","id":"f23ba07ebf2e9c82","name":"White Oak","place_type":"city","bounding_box":rectangle("-84.637123,39.204409 -84.569018,39.232544")},"geo_tag":{"stateID":39,"stateName":"Ohio","countyID":39061,"countyName":"Hamilton","cityID":3984812,"cityName":"White Oak"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044531884032"),"text":"Di ako mag pupuyat mamaya.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"tl","is_retweet":false,"user":{"id":int64("722943621427630081"),"name":"Cristine Mae","screen_name":"Sendangxx","lang":"en","location":"Kissimmee, FL","create_at":date("2016-04-20"),"description":"Prinsesa na abnormal \u274C","followers_count":975,"friends_count":2380,"statues_count":7851},"place":{"country":"United States","country_code":"United States","full_name":"Kissimmee, FL","id":"c2809aa3b2c93fb2","name":"Kissimmee","place_type":"city","bounding_box":rectangle("-81.47749,28.250764 -81.327204,28.347977")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12097,"countyName":"Osceola","cityID":1236950,"cityName":"Kissimmee"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929045073010688"),"text":"@NPCoachRalph Well done! #AroundNewPal","in_reply_to_status":int64("769912371636686848"),"in_reply_to_user":int64("1204389294"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"AroundNewPal"}},"user_mentions":{{1204389294}},"user":{"id":int64("2766725447"),"name":"Bringingtech2you","screen_name":"bringingtech2u","lang":"en","location":"New Palestine, IN","create_at":date("2014-09-10"),"description":"Digital Storyteller via Captured Images | Social Media Brand Strategist |#WomenInBusiness Advocate | Micro Blogger | #bringingtech2you","followers_count":816,"friends_count":1897,"statues_count":2103},"place":{"country":"United States","country_code":"United States","full_name":"New Pal","id":"07d9dd62fe082001","name":"New Pal","place_type":"poi","bounding_box":rectangle("-85.9297091,39.7551529 -85.929709,39.755153")},"coordinate":point("-85.929709,
39.755153"),"geo_tag":{"stateID":18,"stateName":"Indiana","countyID":18059,"countyName":"Hancock"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044695523328"),"text":"My life motto https://t.co/rNl6KdjI0q","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":{"id":int64("1260732067"),"name":"Darclyn","screen_name":"dkatjones14","lang":"en","location":"null","create_at":date("2013-03-11"),"description":"I can do all things through Christ who strengthens me... dancing is my lifestyle 7\u202214\u202216","followers_count":162,"friends_count":250,"statues_count":4092},"place":{"country":"United States","country_code":"United States","full_name":"Porterville, CA","id":"daa5fcec75a430ae","name":"Porterville","place_type":"city","bounding_box":rectangle("-119.080552,36.029555 -118.977713,36.119995")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6107,"countyName":"Tulare","cityID":658240,"cityName":"Porterville"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044343320576"),"text":"First #dragonboat practice this year w/LV Dragon Boat Club. Team practice in a few weeks for the annual... https://t.co/MiOgVPkl4x","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":{{"dragonboat"}},"user":{"id":int64("110500685"),"name":"This Mom Wines","screen_name":"ThisMomWinesLV","lang":"en","location":"Henderson, NV","create_at":date("2010-02-01"),"description":"Crazy-busy #mom and career chick. Recent #ASUgrad, #wine lover, #runner, #community #advocate, #blogger & #Vegas native. Tweets are my own.","followers_count":2345,"friends_count":1702,"statues_count":31425},"place":{"country":"United States","country_code":"United States","full_name":"Nevada, USA","id":"d374fb61a20fb74f","name":"Nevada","place_type":"admin","bounding_box":rectangle("-120.00574,35.002086 -114.039649,42.00
2208")},"coordinate":point("-114.93106327,36.10256306"),"geo_tag":{"stateID":32,"stateName":"Nevada","countyID":32003,"countyName":"Clark","cityID":3231900,"cityName":"Henderson"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929045538549760"),"text":"I've never had a Mcgriddle","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":{"id":int64("4472590819"),"name":"Tay\u2744\uFE0F","screen_name":"_LilTaaay","lang":"en","location":"Houston, TX","create_at":date("2015-12-05"),"description":"varsity cheerleader \u2728","followers_count":455,"friends_count":344,"statues_count":6916},"place":{"country":"United States","country_code":"United States","full_name":"Bellaire, TX","id":"bc39561011b12bc6","name":"Bellaire","place_type":"city","bounding_box":rectangle("-95.484647,29.689372 -95.447422,29.725996")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48201,"countyName":"Harris","cityID":4807300,"cityName":"Bellaire"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044984893440"),"text":"imma tell my grandparents to bring me some more food \uD83D\uDE0A","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":{"id":int64("341283351"),"name":"$.","screen_name":"hayred_","lang":"en","location":"New Orleans, LA \u2708\uFE0F Dallas, TX","create_at":date("2011-07-23"),"description":"don't DM me, you're waisting your time","followers_count":506,"friends_count":354,"statues_count":16551},"place":{"country":"United States","country_code":"United States","full_name":"Denton, TX","id":"f77b0bf942a40070","name":"Denton","place_type":"city","bounding_box":rectangle("-97.187543,33.128938 -97.041998,33.276053")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48121,"countyName":"Denton","cityID":4819972,"cityName":"Denton"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929045358194688"),"text":"@iHipsterLee do a collab with @LILUZIVERT \uD83D\uDD25\uD83D\uDD25\uD83D\uDD25\uD83D\uDD25","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("189801036"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{189801036,1599608046}},"user":{"id":int64("238377468"),"name":"\u2728Kalynn\u2728","screen_name":"KalynnMiles","lang":"en","location":"Los Angeles, CA","create_at":date("2011-01-14"),"description":"\u2728I'm poppin\u2728","followers_count":443,"friends_count":345,"statues_count":1930},"place":{"country":"United States","country_code":"United States","full_name":"Los Angeles, CA","id":"3b77caf94bfc81fe","name":"Los Angeles","place_type":"city","bounding_box":rectangle("-118.668404,33.704538 -118.155409,34.337041")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6037,"countyName":"Los Angeles","cityID":644000,"cityName":"L
os Angeles"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929044225908736"),"text":"https://t.co/v8Y7zicNgf","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":{"id":int64("3650680279"),"name":"Guillermo Silva","screen_name":"gusilemo","lang":"en","location":"null","create_at":date("2015-09-22"),"description":"null","followers_count":2,"friends_count":0,"statues_count":24098},"place":{"country":"United States","country_code":"United States","full_name":"California, USA","id":"fbd6d2f5a4e4a15e","name":"California","place_type":"admin","bounding_box":rectangle("-124.482003,32.528832 -114.131212,42.009519")},"coordinate":point("-123.01247162,37.69942798"),"geo_tag":{"stateID":6,"stateName":"California","countyID":6075,"countyName":"San Francisco","cityID":667000,"cityName":"San Francisco"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929046318645248"),"text":"Doctor thinks Bella could be here anytime between 5-7 weeks, I cannot wait to meet her \uD83D\uDE0D\uD83D\uDC76\uD83C\uDFFC","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":{"id":int64("2878634469"),"name":"Brooklyn","screen_name":"brooooklynbragg","lang":"en","location":"null","create_at":date("2014-11-15"),"description":"my heart belongs to Tyler & Isabella Shannon. soon to be mommy Oct. 2016","followers_count":123,"friends_count":181,"statues_count":3186},"place":{"country":"United States","country_code":"United States","full_name":"Elwood, IN","id":"1fcc8e05dd8c7569","name":"Elwood","place_type":"city","bounding_box":rectangle("-85.869124,40.233425 -85.807713,40.295039")},"geo_tag":{"stateID":18,"stateName":"Indiana","countyID":18095,"countyName":"Madison","cityID":1821070,"cityName"
:"Elwood"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929046000017409"),"text":"Man I'm still drunk lmao what? Today's a good day","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":{"id":int64("706944049429684225"),"name":"Robert Wood","screen_name":"robertwoodam","lang":"en","location":"Tennessee, USA","create_at":date("2016-03-07"),"description":"Let's go. Big plays","followers_count":178,"friends_count":125,"statues_count":6458},"place":{"country":"United States","country_code":"United States","full_name":"Gallatin, TN","id":"e08aaac2b23fd3a3","name":"Gallatin","place_type":"city","bounding_box":rectangle("-86.550888,36.316163 -86.378795,36.428963")},"geo_tag":{"stateID":47,"stateName":"Tennessee","countyID":47165,"countyName":"Sumner","cityID":4728540,"cityName":"Gallatin"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929045827985408"),"text":"McChicken https://t.co/WAwv9WAtTG","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":{"id":int64("993977766"),"name":"sheeray'a","screen_name":"Poesia_Politica","lang":"en","location":"Cleveland","create_at":date("2012-12-06"),"description":"null","followers_count":49,"friends_count":239,"statues_count":808},"place":{"country":"United States","country_code":"United States","full_name":"Columbus, OH","id":"3df0e3eb1e91170b","name":"Columbus","place_type":"city","bounding_box":rectangle("-83.200169,39.832013 -82.771375,40.157354")},"geo_tag":{"stateID":39,"stateName":"Ohio","countyID":39049,"countyName":"Franklin","cityID":3918000,"cityName":"Columbus"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929045828067330"),"text":"MY HUSBAND IS SO HOT LOOK AT HIM https://t.co/G3CwSHVCz4","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":{"id":int64("549674066"),"name":"pop princess","screen_name":"CarlyShore","lang":"en","location":"null","create_at":date("2012-04-09"),"description":"null","followers_count":447,"friends_count":411,"statues_count":5909},"place":{"country":"United States","country_code":"United States","full_name":"Palm Harbor, FL","id":"c5a8a3c8523b835e","name":"Palm Harbor","place_type":"city","bounding_box":rectangle("-82.786128,28.048627 -82.707574,28.1231")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12103,"countyName":"Pinellas","cityID":1254350,"cityName":"Palm Harbor"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929045375016964"),"text":"there's nothing \" lowkey \" \uD83D\uDD11 about my love for him \uD83D\uDC93 https://t.co/sut8yzIzBR","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":{"id":int64("2348377802"),"name":"l i l \u2743","screen_name":"xo_lilly02","lang":"en","location":"null","create_at":date("2014-02-17"),"description":"http://m.apple \uD83D\uDC9B","followers_count":420,"friends_count":368,"statues_count":9383},"place":{"country":"United States","country_code":"United States","full_name":"Los Angeles, CA","id":"3b77caf94bfc81fe","name":"Los Angeles","place_type":"city","bounding_box":rectangle("-118.668404,33.704538 -118.155409,34.337041")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6037,"countyName":"Los Angeles","cityID":644000,"cityName":"Los Angeles"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929046645874689"),"text":"Drink more water.","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":{"id":int64("719302034"),"name":"you","screen_name":"LiferMusic208","lang":"en","location":"Pocatello IDAHO","create_at":date("2012-07-26"),"description":"Real is Rare. Who really cares? if you don't like the road your on start paving another one.","followers_count":1248,"friends_count":726,"statues_count":40426},"place":{"country":"United States","country_code":"United States","full_name":"Pocatello, ID","id":"d15336e5b45c79bb","name":"Pocatello","place_type":"city","bounding_box":rectangle("-112.496051,42.806434 -112.373604,42.920598")},"geo_tag":{"stateID":16,"stateName":"Idaho","countyID":16005,"countyName":"Bannock","cityID":1664090,"cityName":"Pocatello"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929046243340288"),"text":"luv you syd!! \u2764\uFE0F\u2764\uFE0F\u2764\uFE0F\u2764\uFE0F https://t.co/OfPWCtDQ1n","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":{"id":int64("3085265295"),"name":"lailai","screen_name":"laiyoncee","lang":"en","location":"null","create_at":date("2015-03-10"),"description":"then there's me","followers_count":1078,"friends_count":407,"statues_count":22582},"place":{"country":"United States","country_code":"United States","full_name":"Chicago, IL","id":"1d9a5370a355ab0c","name":"Chicago","place_type":"city","bounding_box":rectangle("-87.940033,41.644102 -87.523993,42.023067")},"geo_tag":{"stateID":17,"stateName":"Illinois","countyID":17031,"countyName":"Cook","cityID":1714000,"cityName":"Chicago"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929046494937092"),"text":"Me & ChiChi Is Due For A Date","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":{"id":int64("237555768"),"name":"kkay\u2763\uFE0F","screen_name":"_aaaalyak","lang":"en","location":"null","create_at":date("2011-01-12"),"description":"null","followers_count":1147,"friends_count":693,"statues_count":87933},"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"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929046817779716"),"text":"The new @fettywap track is giving me life rn \uD83D\uDE0E","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":{{2601175671}},"user":{"id":int64("816653695"),"name":"Katie.","screen_name":"KatieTaylorGang","lang":"en","location":"Houston, Texas","create_at":date("2012-09-10"),"description":"Marketing Director. University of Houston Grad. Go Coogs","followers_count":760,"friends_count":474,"statues_count":7034},"place":{"country":"United States","country_code":"United States","full_name":"Houston, TX","id":"1c69a67ad480e1b1","name":"Houston","place_type":"city","bounding_box":rectangle("-95.823268,29.522325 -95.069705,30.154665")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48201,"countyName":"Harris","cityID":4835000,"cityName":"Houston"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929046587215874"),"text":"Lol @whoooolz YES way @flumemusic set me free last night \uD83D\uDC50\uD83C\uDFFC\uD83D\uDC45\u2728\uD83D\uDC99 @\u2026 https://t.co/mA4a5ZOFFX","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":{{143445593,297882651}},"user":{"id":int64("502100576"),"name":"adolf","screen_name":"rissyyyyyyyy","lang":"en","location":"lost in the crowd","create_at":date("2012-02-24"),"description":"dude I'm a mermaid","followers_count":506,"friends_count":431,"statues_count":23015},"place":{"country":"United States","country_code":"United States","full_name":"Queens, NY","id":"00c39537733fa112","name":"Queens","place_type":"city","bounding_box":rectangle("-73.962582,40.541722 -73.699793,40.800037")},"coordinate":point("-73.84927797,40.71991471"),"geo_tag":{"stateID":36,"stateName":"New York","count
yID":36081,"countyName":"Queens","cityID":36081,"cityName":"Queens"}}
+{"create_at":datetime("2016-08-28T09:06:03.000"),"id":int64("769929046339780609"),"text":"@heyifeellike @rachel_dufty","in_reply_to_status":int64("769781692663943169"),"in_reply_to_user":int64("1468571624"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"user_mentions":{{1468571624,2374524218}},"user":{"id":int64("2396646080"),"name":"Hayden(:","screen_name":"haydenaudrey02","lang":"en","location":"null","create_at":date("2014-03-18"),"description":"F.C. Union Mi\u26BD\uFE0F","followers_count":406,"friends_count":1343,"statues_count":5398},"place":{"country":"United States","country_code":"United States","full_name":"Troy, MI","id":"4e284ea3fff91c09","name":"Troy","place_type":"city","bounding_box":rectangle("-83.209206,42.533782 -83.086881,42.624224")},"geo_tag":{"stateID":26,"stateName":"Michigan","countyID":26125,"countyName":"Oakland","cityID":2680700,"cityName":"Troy"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929046914375680"),"text":"@GFOOLEY 125 will suffice I'm not even gonna tax you","in_reply_to_status":int64("769928602423062528"),"in_reply_to_user":int64("237523183"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{237523183}},"user":{"id":int64("930847412"),"name":"yoko chanel","screen_name":"scozzyyoko","lang":"en","location":"DC||ATL","create_at":date("2012-11-06"),"description":"yoko has returned they cry...","followers_count":1094,"friends_count":555,"statues_count":71183},"place":{"country":"United States","country_code":"United States","full_name":"Atlanta, GA","id":"8173485c72e78ca5","name":"Atlanta","place_type":"city","bounding_box":rectangle("-84.576827,33.647503 -84.289385,33.886886")},"geo_tag":{"stateID":13,"stateName":"Georgia","countyID":13121,"countyName":"Fulton","cityID":1304000,"cityName":"Atlanta"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929046914240513"),"text":"@Ms_Miri I did it once, people were hardcore...bring a towel you gonna sweat girl","in_reply_to_status":int64("769927228146671616"),"in_reply_to_user":int64("275801072"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{275801072}},"user":{"id":int64("224479831"),"name":"ImranQ","screen_name":"ImranQ805","lang":"en","location":"Studio City, Los Angeles","create_at":date("2010-12-08"),"description":"#Clippers #Angels #Rams #GKG #IQjotd. I don't want to grow up. I don't want to grow up. If growing up means being like you. Then I dont want to be like you.\u270C","followers_count":551,"friends_count":644,"statues_count":37183},"place":{"country":"United States","country_code":"United States","full_name":"Los Angeles, CA","id":"3b77caf94bfc81fe","name":"Los Angeles","place_type":"city","bounding_box":rectangle("-118.668404,33.704538 -118.155409,3
4.337041")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6037,"countyName":"Los Angeles","cityID":644000,"cityName":"Los Angeles"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929047052779520"),"text":"were arguing over how much boneless wings cost. \uD83D\uDE11","in_reply_to_status":int64("769919242804363265"),"in_reply_to_user":int64("2427775609"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user":{"id":int64("2427775609"),"name":"bails","screen_name":"xoxobaii","lang":"en","location":"nature","create_at":date("2014-04-04"),"description":"Lucidious // Sincerely Yours","followers_count":815,"friends_count":945,"statues_count":18131},"place":{"country":"United States","country_code":"United States","full_name":"Durand, MI","id":"5c14e13491807c2c","name":"Durand","place_type":"city","bounding_box":rectangle("-84.011944,42.900403 -83.972297,42.928967")},"geo_tag":{"stateID":26,"stateName":"Michigan","countyID":26155,"countyName":"Shiawassee","cityID":2623500,"cityName":"Durand"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929046922780673"),"text":"Realizing our collective power, teaching by example, Hot Dang - We're Alive! #yogarocksthepark\u2026 https://t.co/iS6FSB8Ai6","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":{{"yogarocksthepark"}},"user":{"id":int64("304484756"),"name":"Ti - theCodingYogini","screen_name":"TiWegmeyer","lang":"en","location":"Denver, CO","create_at":date("2011-05-24"),"description":"Living my Yoga","followers_count":39,"friends_count":256,"statues_count":189},"place":{"country":"United States","country_code":"United States","full_name":"Denver, CO","id":"b49b3053b5c25bf5","name":"Denver","place_type":"city","bounding_box":rectangle("-105.109815,39.614151 -104.734372,39.812975")},"coordinate":point("-104.993366,39.73087"),"geo_tag":{"stateID":8,"stateName":"Colorado","countyID":8031,"countyName":"Denve
r","cityID":820000,"cityName":"Denver"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929047686180864"),"text":"@WhiteBoyWade15 @iRose_ThanBloom we studied under THE bird brown","in_reply_to_status":int64("769928139401113600"),"in_reply_to_user":int64("499427722"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{499427722,608360025}},"user":{"id":int64("1250458676"),"name":"Justin Green","screen_name":"Wolver_Green","lang":"en","location":"null","create_at":date("2013-03-07"),"description":"CCCC SU 19'","followers_count":421,"friends_count":180,"statues_count":9398},"place":{"country":"United States","country_code":"United States","full_name":"Salisbury, MD","id":"00caf39d503a84e9","name":"Salisbury","place_type":"city","bounding_box":rectangle("-75.71412,38.28923 -75.487032,38.431613")},"geo_tag":{"stateID":24,"stateName":"Maryland","countyID":24045,"countyName":"Wicomico","cityID":2469925,"cityName":"Salisbury"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929047740715008"),"text":"I like how Hansen wears that random piece of leather to hide his gut. Who cares about any of these fat fucks?\n#WatchROH","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":{{"WatchROH"}},"user":{"id":int64("74214410"),"name":"sevenwithcheese","screen_name":"sevenwithcheese","lang":"en","location":"Pittsburgh, PA","create_at":date("2009-09-14"),"description":"We are not the same. I'm an American. You're a sick asshole.","followers_count":1244,"friends_count":404,"statues_count":221941},"place":{"country":"United States","country_code":"United States","full_name":"Pittsburgh, PA","id":"946ccd22e1c9cda1","name":"Pittsburgh","place_type":"city","bounding_box":rectangle("-80.095586,40.36158 -79.865793,40.501198")},"geo_tag":{"stateID":42,"stateName":"Pennsylvania","countyID":42003,"countyNa
me":"Allegheny","cityID":4261000,"cityName":"Pittsburgh"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929047270764544"),"text":"who do u love i wanna lounge wit u https://t.co/n9XZWYCwts","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":{"id":int64("407377447"),"name":"Amy Pham","screen_name":"iamamypham","lang":"en","location":"Los Angeles, CA","create_at":date("2011-11-07"),"description":"DJ / HOST / ACTRESS / PIZZA","followers_count":20074,"friends_count":314,"statues_count":4363},"place":{"country":"United States","country_code":"United States","full_name":"FYF Fest","id":"07d9e1fb67882001","name":"FYF Fest","place_type":"poi","bounding_box":rectangle("-118.2886941,34.015403899999995 -118.288694,34.015404")},"coordinate":point("-118.288694,34.015404"),"geo_tag":{"stateID":6,"stateName":"California","countyID":6037,"countyName":"Los Angeles","cityID":644000,"cityName":"Los Angeles"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929048281710592"),"text":"When you're sick but still have to run the sound board for morning #worship! Early mornings\u2026 https://t.co/gYwlyLBVE9","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":{{"worship"}},"user":{"id":int64("1073904494"),"name":"Sykter Ink Media","screen_name":"SykterInkMedia","lang":"en","location":"Canada","create_at":date("2013-01-09"),"description":"Mission Statement: To provide a constant source of encouragement in order to build up and connect us all as one universal community.","followers_count":87,"friends_count":367,"statues_count":394},"place":{"country":"Canada","country_code":"Canada","full_name":"Prince George, British Columbia","id":"0582c884a3ab504d","name":"Prince George","place_type":"city","bounding_box":rectangle("-122.900929,53.812891 -122.604368,54.043014")},"coordi
nate":point("-122.80065161,53.85577729"),"geo_tag":{"stateID":2,"stateName":"Alaska","countyID":2016,"countyName":"Aleutians West"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929049053343744"),"text":"anyone going to lagoon today?","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":{"id":int64("2730856314"),"name":"noah bachman","screen_name":"noahb7_","lang":"en","location":"Salt Lake, UT","create_at":date("2014-08-13"),"description":"nobody's that good","followers_count":334,"friends_count":353,"statues_count":456},"place":{"country":"United States","country_code":"United States","full_name":"South Jordan, UT","id":"b76a96fd566f9172","name":"South Jordan","place_type":"city","bounding_box":rectangle("-112.031592,40.536852 -111.894963,40.582109")},"geo_tag":{"stateID":49,"stateName":"Utah","countyID":49035,"countyName":"Salt Lake","cityID":4970850,"cityName":"South Jordan"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929048990580736"),"text":"For the last 3 weeks I've been working and have no time it chill \uD83D\uDE1E shit sucks","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":{"id":int64("1048872067"),"name":"\u017Eoomonkey","screen_name":"Pharaoh_Jr","lang":"en","location":"Winter Haven, FL","create_at":date("2012-12-30"),"description":"hey I'm junior & yeah| Carrabba's| gym|Game designer| Artist| #SnowGang| Instagram: pharaoh_jr101 | Snapchat: juniorhyppolite|","followers_count":524,"friends_count":391,"statues_count":10339},"place":{"country":"United States","country_code":"United States","full_name":"Winter Haven, FL","id":"6098c1080dfc7af3","name":"Winter Haven","place_type":"city","bounding_box":rectangle("-81.770135,27.939559 -81.627638,28.095052")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12105,"coun
tyName":"Polk","cityID":1278275,"cityName":"Winter Haven"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929048705212417"),"text":"Enjoying this show. Ozzy+History =comfort. \uD83D\uDE43 https://t.co/Qg6gLDkodl","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":{"id":int64("297078789"),"name":"Robin Courter","screen_name":"tuesdaydreams","lang":"en","location":"Winterfell","create_at":date("2011-05-11"),"description":"Forever Presley's person. Junk Food Vegetarian. Born on a Tuesday. Here for the chatter. #StrongerTogether","followers_count":153,"friends_count":592,"statues_count":3212},"place":{"country":"United States","country_code":"United States","full_name":"Coram, NY","id":"92e1e697abf56722","name":"Coram","place_type":"city","bounding_box":rectangle("-73.039115,40.837693 -72.972416,40.921065")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36103,"countyName":"Suffolk","cityID":3618157,"cityName":"C
oram"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929049737195520"),"text":"Sunday enjoying the reminding warm days of summer","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":{"id":int64("163215561"),"name":"Jose Espejo","screen_name":"jlespejo72","lang":"en","location":"Chicago, Illinois","create_at":date("2010-07-05"),"description":"Architect/Designer","followers_count":101,"friends_count":426,"statues_count":2248},"place":{"country":"United States","country_code":"United States","full_name":"Chicago, IL","id":"1d9a5370a355ab0c","name":"Chicago","place_type":"city","bounding_box":rectangle("-87.940033,41.644102 -87.523993,42.023067")},"geo_tag":{"stateID":17,"stateName":"Illinois","countyID":17031,"countyName":"Cook","cityID":1714000,"cityName":"Chicago"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929050068426752"),"text":"Great race fellas. Congrats @nico_rosberg @danielricciardo @LewisHamilton . That was a fun weekend. #BelgiumGP #F1","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":{{"BelgiumGP","F1"}},"user_mentions":{{115044590,214413743,213969309}},"user":{"id":int64("367388829"),"name":"Chris Bythewood","screen_name":"Cbyt","lang":"en","location":"LA/ NY","create_at":date("2011-09-03"),"description":"Writer- Shots Fired on Fox. Lover of all Sports. Tryer of new things. #ShotsFiredFox premiering Spring 2017 http://www.fox.com/shots-fired","followers_count":514,"friends_count":469,"statues_count":4658},"place":{"country":"United States","country_code":"United States","full_name":"Los Angeles, CA","id":"3b77caf94bfc81fe","name":"Los Angeles","place_type":"city","bounding_box":rectangle("-118.668404,
33.704538 -118.155409,34.337041")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6037,"countyName":"Los Angeles","cityID":644000,"cityName":"Los Angeles"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929049808396289"),"text":"@StevenJV Interesting. How can you leave one Tart in the package? It's already open! Can't do it. Gotta eat both. It's a moral imperative.","in_reply_to_status":int64("769928647310315520"),"in_reply_to_user":int64("1174791"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{1174791}},"user":{"id":int64("33433404"),"name":"Jerry Fahrni","screen_name":"JFahrni","lang":"en","location":"Fresno, Caifornia","create_at":date("2009-04-19"),"description":"Pharmacist with interest in automation and technology whether it's related to healthcare or not. Consultant, speaker, dad, husband, football fan. Central Valley","followers_count":1718,"friends_count":380,"statues_count":22054},"place":{"country":"United States","country_code":"United States","full_name":"Fresno, CA","id":"944c03c1d85ef480","name":"Fresno","place_type":"city","bounding_box":rectangl
e("-119.93251,36.648905 -119.632419,36.923179")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6019,"countyName":"Fresno","cityID":627000,"cityName":"Fresno"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929051008106496"),"text":"Beginning set given land form. Forth i seed signs she'd meat light divided they're. Make.","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":{"id":int64("3976141697"),"name":"Patricia Snyder","screen_name":"pasnoda","lang":"en","location":"null","create_at":date("2015-10-16"),"description":"null","followers_count":17,"friends_count":0,"statues_count":32985},"place":{"country":"United States","country_code":"United States","full_name":"California, USA","id":"fbd6d2f5a4e4a15e","name":"California","place_type":"admin","bounding_box":rectangle("-124.482003,32.528832 -114.131212,42.009519")},"coordinate":point("-123.01228019,37.69913047"),"geo_tag":{"stateID":6,"stateName":"California","countyID":6075,"countyName":"San Francisco","cityID":667000,"cityName":"San Francisco"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929051205144576"),"text":"Truth by @ThePirch #pirch #kitchen #design #home #quotes #food #cupcakes #sweets #dessert #fun\u2026 https://t.co/37zkjN7XBS","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":{{"pirch","kitchen","design","home","quotes","food","cupcakes","sweets","dessert","fun"}},"user":{"id":int64("40921996"),"name":"Sarah Lipton","screen_name":"sarah4canes","lang":"en","location":"San Diego, CA","create_at":date("2009-05-18"),"description":"Floridian trying out West Coast life - PR pro - USMC wife","followers_count":511,"friends_count":1921,"statues_count":1951},"place":{"country":"United States","country_code":"United States","full_name":"San Diego, CA","id":"a592bd6ceb1319f7","name":"San Diego","place_type":"city","bounding_box":rectangle("-117.282538,32.53962 -116.92744,33.080404")},"coordinate"
:point("-117.2098658,32.8736134"),"geo_tag":{"stateID":6,"stateName":"California","countyID":6073,"countyName":"San Diego","cityID":666000,"cityName":"San Diego"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929051662200832"),"text":"If he can't look you in your eyes, he lying.","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":{"id":int64("1975745216"),"name":"Jeremy Bazan","screen_name":"BazanJeremy","lang":"en","location":"Weslaco, tx ","create_at":date("2013-10-20"),"description":"22. iLift. DreamChaser. Father First. SC: jeremy_bazan24 \u270C\uFE0F","followers_count":843,"friends_count":1443,"statues_count":6013},"place":{"country":"United States","country_code":"United States","full_name":"Gonzales, LA","id":"82a3427fa492ed52","name":"Gonzales","place_type":"city","bounding_box":rectangle("-90.959148,30.167772 -90.820958,30.292323")},"geo_tag":{"stateID":22,"stateName":"Louisiana","countyID":22005,"countyName":"Ascension","cityID":2229850,"cityName":"Gonzales"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929049061810176"),"text":"\uD83D\uDE0C\uD83D\uDE0C\uD83D\uDE0C https://t.co/IPl1mF3ZQL","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":{"id":int64("2209223862"),"name":"b moore","screen_name":"superradbrad","lang":"en","location":"hails","create_at":date("2013-11-22"),"description":"null","followers_count":285,"friends_count":329,"statues_count":2972},"place":{"country":"United States","country_code":"United States","full_name":"Tulsa, OK","id":"cb74aaf709812e0f","name":"Tulsa","place_type":"city","bounding_box":rectangle("-96.065628,35.968624 -95.761656,36.250159")},"geo_tag":{"stateID":40,"stateName":"Oklahoma","countyID":40143,"countyName":"Tulsa","cityID":4075000,"cityName":"Tulsa"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929049661698048"),"text":"Back To School Dance \u2B50\uFE0F\uD83D\uDC9E\uD83D\uDD25 https://t.co/YlTODhiAut","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":{"id":int64("2409854756"),"name":"Mariee\u2764\uFE0F","screen_name":"JohnmarieB","lang":"en","location":"null","create_at":date("2014-03-24"),"description":"~There is no fear in love, but Gods perfect love drives out fear~ 1 John 4:18 DKG\u2764\uFE0F Young&Blessed","followers_count":1450,"friends_count":1386,"statues_count":15383},"place":{"country":"United States","country_code":"United States","full_name":"Avondale, LA","id":"a84a422764eaf197","name":"Avondale","place_type":"city","bounding_box":rectangle("-90.221926,29.881335 -90.167855,29.930316")},"geo_tag":{"stateID":22,"stateName":"Louisiana","countyID":22051,"countyName":"Jefferson","cityID":2203810,"
cityName":"Avondale"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929051481993216"),"text":"@Yummiieee__ Don't regret it though lol","in_reply_to_status":int64("769928950395068416"),"in_reply_to_user":int64("1400900870"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{1400900870}},"user":{"id":int64("341280524"),"name":"Master Debater \u2649","screen_name":"LameGuyTy","lang":"en","location":"CLEVELAND","create_at":date("2011-07-23"),"description":"In order to succeed your desire for success should be greater than your fear of failure. 3-7-14 But if you really wanna go hard.... U.S Army 13B","followers_count":1250,"friends_count":1116,"statues_count":33903},"place":{"country":"United States","country_code":"United States","full_name":"Lakewood, OH","id":"888482aa70a3bc61","name":"Lakewood","place_type":"city","bounding_box":rectangle("-81.8375,41.463245 -81.768603,41.49759")},"geo_tag":{"stateID":39,"stateName":"Ohio","countyID":3
9035,"countyName":"Cuyahoga","cityID":3941664,"cityName":"Lakewood"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929052228427776"),"text":"I havent been that high in a while","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":{"id":int64("1317722118"),"name":"Erikson","screen_name":"__ErikV","lang":"en","location":"Des Moines, IA","create_at":date("2013-03-30"),"description":"ig : Evj420","followers_count":360,"friends_count":283,"statues_count":7010},"place":{"country":"United States","country_code":"United States","full_name":"Des Moines, IA","id":"1c67f9d9cbae7f69","name":"Des Moines","place_type":"city","bounding_box":rectangle("-93.709504,41.501409 -93.503235,41.651466")},"geo_tag":{"stateID":19,"stateName":"Iowa","countyID":19153,"countyName":"Polk","cityID":1921000,"cityName":"Des Moines"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929051028848640"),"text":"Lovely night celebrating @chargergirl80 birthday with @maggi09 - happy birthday Glynnda love you #friends \uD83D\uDE18\u2764\uFE0F https://t.co/ia6b44bMgR","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":{{"friends"}},"user_mentions":{{37336740,19871655}},"user":{"id":int64("375300259"),"name":"Cassy Thorpe","screen_name":"cassythorpe","lang":"en","location":"Lewisham, South East London","create_at":date("2011-09-17"),"description":"I love london & my bajan roots","followers_count":168,"friends_count":161,"statues_count":1989},"place":{"country":"United States","country_code":"United States","full_name":"Paradise, NV","id":"8fa6d7a33b83ef26","name":"Paradise","place_type":"city","bounding_box":rectangle("-115.209254,35.984784 -115.061076,36.137145")},"geo_tag":{"stateID":32,"stateNam
e":"Nevada","countyID":32003,"countyName":"Clark","cityID":3254600,"cityName":"Paradise"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929052350210048"),"text":"Sept. 10 cant get here any faster great birthday present to me @CMPunk ..good luck dude.im pulling for ya man!","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":{{177345928}},"user":{"id":int64("921422222"),"name":"chad hoover dimera","screen_name":"chadhooverdimer","lang":"en","location":"anywhere town usa","create_at":date("2012-11-02"),"description":"white dude","followers_count":81,"friends_count":99,"statues_count":529},"place":{"country":"United States","country_code":"United States","full_name":"Dundalk, MD","id":"808665307aa255fe","name":"Dundalk","place_type":"city","bounding_box":rectangle("-76.529818,39.222702 -76.447351,39.306282")},"geo_tag":{"stateID":24,"stateName":"Maryland","countyID":24005,"countyName":"Baltimore","cityID":2423975,"cityName":"Dundalk"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929052345999360"),"text":"on sum faded luv \uD83D\uDE0B","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":{"id":int64("3925699045"),"name":"Brittaney.","screen_name":"_brittaneytheis","lang":"en","location":"Weatherford, OK","create_at":date("2015-10-17"),"description":"leave every bottle as empty as my promises","followers_count":504,"friends_count":402,"statues_count":9105},"place":{"country":"United States","country_code":"United States","full_name":"Weatherford, OK","id":"7da27eb58e1638f5","name":"Weatherford","place_type":"city","bounding_box":rectangle("-98.725251,35.517222 -98.626215,35.558904")},"geo_tag":{"stateID":40,"stateName":"Oklahoma","countyID":40039,"countyName":"Custer","cityID":4079450,"cityName":"Weatherford"}}
+{"create_at":datetime("2016-08-28T09:06:04.000"),"id":int64("769929050764771328"),"text":"https://t.co/MAJYOYm6wh","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":{"id":int64("750822905077006336"),"name":"Lori smith","screen_name":"POstableproud","lang":"en","location":"Georgia, USA","create_at":date("2016-07-06"),"description":"Fan girl of #SSD #POstables and Downton Abbey","followers_count":71,"friends_count":126,"statues_count":4267},"place":{"country":"United States","country_code":"United States","full_name":"Trenton, GA","id":"01a31c587ddd0f28","name":"Trenton","place_type":"city","bounding_box":rectangle("-85.523271,34.85373 -85.492643,34.897411")},"geo_tag":{"stateID":13,"stateName":"Georgia","countyID":13083,"countyName":"Dade","cityID":1377372,"cityName":"Trenton"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929053000245249"),"text":"Muero \uD83D\uDC37 https://t.co/jx8mATZYnv","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"es","is_retweet":false,"user":{"id":int64("3249498035"),"name":"Dani Porras \u2741","screen_name":"daniporras6","lang":"en","location":"null","create_at":date("2015-05-12"),"description":"null","followers_count":150,"friends_count":245,"statues_count":5933},"place":{"country":"United States","country_code":"United States","full_name":"Plantation, FL","id":"7df9a00dcf914d5e","name":"Plantation","place_type":"city","bounding_box":rectangle("-80.330201,26.088262 -80.196833,26.160753")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12115,"countyName":"Sarasota","cityID":1257450,"cityName":"Plantation"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929052442337280"),"text":"I bet they all sing the lyrics to this song. https://t.co/TcBC1FG4nK","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":{"id":int64("377261318"),"name":"Malik Moor\u00E8","screen_name":"mylifeasmalik","lang":"en","location":"texas","create_at":date("2011-09-21"),"description":"EWU' 20","followers_count":1176,"friends_count":391,"statues_count":32269},"place":{"country":"United States","country_code":"United States","full_name":"Moses Lake, WA","id":"513be78e6847eb1a","name":"Moses Lake","place_type":"city","bounding_box":rectangle("-119.363589,47.078794 -119.241434,47.162879")},"geo_tag":{"stateID":53,"stateName":"Washington","countyID":53025,"countyName":"Grant","cityID":5347245,"cityName":"Moses Lake"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929053130354688"),"text":"@BrittanytB i'm dying lmao","in_reply_to_status":int64("769918557752795136"),"in_reply_to_user":int64("51127889"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{51127889}},"user":{"id":int64("142462927"),"name":"alex","screen_name":"theSASHAfierce_","lang":"en","location":"Temple University","create_at":date("2010-05-10"),"description":"Tiramisu aficionado","followers_count":658,"friends_count":450,"statues_count":37752},"place":{"country":"United States","country_code":"United States","full_name":"Philadelphia, PA","id":"e4a0d228eb6be76b","name":"Philadelphia","place_type":"city","bounding_box":rectangle("-75.280284,39.871811 -74.955712,40.13792")},"geo_tag":{"stateID":42,"stateName":"Pennsylvania","countyID":42101,"countyName":"Philadelphia","cityID":4260000,"cityName":"Philadelphia"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929053381988352"),"text":"Another amazing trip, #NYC see you soon... Next stop #Amsterdam","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":{{"NYC","Amsterdam"}},"user":{"id":int64("4318226487"),"name":"Sup Goyal","screen_name":"Sup_Goyal","lang":"en","location":"New York, NY","create_at":date("2015-11-29"),"description":"Instagram - @supgoyal","followers_count":196,"friends_count":254,"statues_count":77},"place":{"country":"United States","country_code":"United States","full_name":"Times Square","id":"07d9db04e7c85001","name":"Times Square","place_type":"poi","bounding_box":rectangle("-73.98626809999999,40.7564899 -73.986268,40.75649")},"coordinate":point("-73.986268,40.75649"),"geo_tag":{"stateID":36,"stateName":"New York","countyID":36061,"countyName":"New York","cityID":36061,"cityName":"Manhattan"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929053365166080"),"text":"Did you catch that??? https://t.co/6LmiS3qfMZ","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":{"id":int64("86201399"),"name":"Johnny Olavarria","screen_name":"Olavarriajs","lang":"en","location":"null","create_at":date("2009-10-29"),"description":"United States Air Force Academy graduate; born Dom Rep & raised in NYC; true believer in what makes America GREAT; proud of our constitution; and NO free shit.","followers_count":558,"friends_count":990,"statues_count":4341},"place":{"country":"United States","country_code":"United States","full_name":"Fort Lauderdale, FL","id":"6c686af766d8429c","name":"Fort Lauderdale","place_type":"city","bounding_box":rectangle("-80.20811,26.080935 -80.090235,26.219801")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12011,"countyName":"Broward"
,"cityID":1224000,"cityName":"Fort Lauderdale"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929053771960320"),"text":"The same people that fronted on you will say \"I always knew you could do it\" when you make it.","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":{"id":int64("90442557"),"name":"DAT TRILL MF\u264F","screen_name":"TheGr0ve","lang":"en","location":"Long Beach, Ca","create_at":date("2009-11-16"),"description":"Long Beach, CA 90806\nLet The Force Be With You\n#SmokingSectionPodcast Coming soon!!!\nInstagram: @Dtatelb","followers_count":262,"friends_count":158,"statues_count":19256},"place":{"country":"United States","country_code":"United States","full_name":"Los Angeles, CA","id":"3b77caf94bfc81fe","name":"Los Angeles","place_type":"city","bounding_box":rectangle("-118.668404,33.704538 -118.155409,34.337041")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6037,"countyName":"Los
Angeles","cityID":644000,"cityName":"Los Angeles"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929053952471044"),"text":"@nochiefs @mooshakins @Peetweefish @DaveinTexas Unrelated: I don't think Paddy was even born when the McDLT was introduced or discontinued.","in_reply_to_status":int64("769928376945512448"),"in_reply_to_user":int64("14078674"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{14078674,375194919,705544666469404674,14706964}},"user":{"id":int64("390223259"),"name":"Scott, As Seen on TV","screen_name":"DunsScottus","lang":"en","location":"Virginia / Washington, DC Area","create_at":date("2011-10-13"),"description":"Conservative/libertarian. Catholic. Previously a software engineer for more than a decade, now an attorney. Opinions are my own. \u039C\u039F\u039B\u03A9\u039D \u039B\u0391\u0392\u0395","followers_count":629,"friends_count":530,"statues_count":30605},"place":{"country":"United States","country_code":"United States","full_name":"Alexa
ndria, VA","id":"d6819fe60643ebc1","name":"Alexandria","place_type":"city","bounding_box":rectangle("-77.144435,38.789907 -77.037304,38.844853")},"geo_tag":{"stateID":51,"stateName":"Virginia","countyID":51059,"countyName":"Fairfax","cityID":5101000,"cityName":"Alexandria"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929054182977536"),"text":"@BeckyDamissus yep in Reno now.Thanks again for sorting the tickets ...","in_reply_to_status":int64("769680785859227648"),"in_reply_to_user":int64("594144678"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{594144678}},"user":{"id":int64("79210652"),"name":"Sam Trickett","screen_name":"Samtrickett1","lang":"en","location":"null","create_at":date("2009-10-02"),"description":"Official Page of Sam Trickett - Professional Poker Player - http://Facebook.com/Sam.trickett - http://Instagram.com/samtrickett7","followers_count":57157,"friends_count":7219,"statues_count":3844},"place":{"country":"United States","country_code":"United States","full_name":"Reno, NV","id":"4b25aded08900fd8","name":"Reno","place_type":"city","bounding_box":rectangle("-119.953849,39.350749 -119.700515,39.674123")},"geo_tag":{"stateID":32,"stateName":"Nevada","countyID":
32031,"countyName":"Washoe","cityID":3260600,"cityName":"Reno"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929054526943233"),"text":"Not ready for classes to start","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":{"id":int64("61600111"),"name":"ash","screen_name":"Ashlyn58","lang":"en","location":"null","create_at":date("2009-07-30"),"description":"Harry Styles and pizza slices\u2764\uFE0F","followers_count":360,"friends_count":335,"statues_count":21224},"place":{"country":"United States","country_code":"United States","full_name":"Nacogdoches, TX","id":"ebf78e870cecf27c","name":"Nacogdoches","place_type":"city","bounding_box":rectangle("-94.704218,31.55485 -94.594405,31.673033")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48347,"countyName":"Nacogdoches","cityID":4850256,"cityName":"Nacogdoches"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929054677970944"),"text":"Do you want to be people IN the way of people OF the way?\n- @cmsloan00 \n#TWCKinston","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":{{"TWCKinston"}},"user_mentions":{{234931359}},"user":{"id":int64("552335577"),"name":"Harley Gracen Smith","screen_name":"harley_gracen94","lang":"en","location":"Kinston, NC","create_at":date("2012-04-12"),"description":"[The heart of man plans his way, but the Lord establishes his steps. \u2022Proverbs 16:9\u2022] //Jesus and Coffee are the way to my heart//","followers_count":314,"friends_count":339,"statues_count":3315},"place":{"country":"United States","country_code":"United States","full_name":"Kinston, NC","id":"1427f884feb4cb70","name":"Kinston","place_type":"city","bounding_box":rectangle("-77.652885,35.227946 -77.543004,35.323017")},"geo_t
ag":{"stateID":37,"stateName":"North Carolina","countyID":37107,"countyName":"Lenoir","cityID":3735920,"cityName":"Kinston"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929054740844544"),"text":"things i like: $$\nthings i don't like: working til 12 last night and having to be back for a 7 hour shift at 1pm","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":{"id":int64("2415876928"),"name":"emilia grace","screen_name":"emmyyyyfischer","lang":"en","location":"thotbox pizza","create_at":date("2014-03-16"),"description":"going real slow down the highway of life with no regrets","followers_count":376,"friends_count":571,"statues_count":6117},"place":{"country":"United States","country_code":"United States","full_name":"Noblesville, IN","id":"013e3bc05a18abdc","name":"Noblesville","place_type":"city","bounding_box":rectangle("-86.090354,39.993436 -85.932944,40.10716")},"geo_tag":{"stateID":18,"stateName":"Indiana","countyID":18057,"countyName":"Hamilton","cityID":1854180,"cityName":"No
blesville"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929054539636736"),"text":"Saturday in the park \uD83C\uDDE8\uD83C\uDDF1\u26BE\uFE0F @ Globe Life Park in Arlington https://t.co/O3Q38hOiuD","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":{"id":int64("18689312"),"name":"K\u2B50\uFE0FD0\u20E3M\u2B50\uFE0F","screen_name":"KADOMA","lang":"en","location":"3814 S. Shepherd Dr. HTX 77098","create_at":date("2009-01-06"),"description":"FOUNDER: #SneakerSummit\u00AE | CONTRIBUTOR: #TeamTrill #YGET | IG/Snap: Kadoma713 | 2016 DATES: #HTown @nrgparkfan Sun. 12/4, #TexasSkateJam @southsidehtx Sat. 11/5","followers_count":2279,"friends_count":1619,"statues_count":19667},"place":{"country":"United States","country_code":"United States","full_name":"Arlington, TX","id":"6e315e1f96e0450a","name":"Arlington","place_type":"city","bounding_box":rectangle("-97.233811,32.586565 -97.0
37464,32.817135")},"coordinate":point("-97.08253,32.7513099"),"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48439,"countyName":"Tarrant","cityID":4804000,"cityName":"Arlington"}}
+{"create_at":datetime("2016-08-28T09:06:05.000"),"id":int64("769929054925492228"),"text":"I'm deadass bipolar and I'm crazy so please, do ya self a favor and stay away from me!","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":{"id":int64("3452631862"),"name":"Oceana\u2728\u2766","screen_name":"Raven_A_HD","lang":"en","location":"
<TRUNCATED>