Created
August 20, 2018 14:10
-
-
Save rsangole/27e7575438847a8457c59c089ef2793a to your computer and use it in GitHub Desktop.
SQL query issues
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| query <- "SELECT uid, timestamp, sensor_1 FROM database_name.long_table_name_here WHERE ((uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02'))" |
What works:
query <- "SELECT uid, timestamp, sensor_1 FROM database_name.long_table_name_here WHERE ((uid = 'abxyz1230' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02') OR (uid = 'abxyz1236' AND filter_id = '1' AND timestamp >= '2018-07-23' AND timestamp <= '2018-08-02'))"
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
platform x86_64-pc-linux-gnu
arch x86_64
os linux-gnu
system x86_64, linux-gnu
major 3
minor 3.3
language R
version.string R version 3.3.3 (2017-03-06)
nickname Another Canoe