ecode | Yima - build your temple of knowledge

OR is not supported by Cassandra...

Alex is correct. Cassandra does not support the OR keyword. It's one of the differences between CQL and SQL. In fact, given Cassandra's storage model, an OR construct is particularly problematic.

How can I achieve this scenario?

I can think of a few ways.

With Cassandra, the general idea with data modeling is to build your tables to suit your queries. So the first, would be to apply the logic on the data load, but your logic may be too complex for that.

You could also split this query into two queries (based on your AND conditions) and process the result sets on the application side. Not optimal, but it might be the only way to get the fine-grained control you need.

The other approach, would be to try using IN to get around the absence of OR. Just be careful not to restrict your partition key with IN, and always specify your partition key (with an = operator) when you do. That way you'll limit your query to processing on a single node. In fact, using IN on a clustering key (again, with = on your partition key) is really the only way I would recommend its use in a production system.

While doing some research on the topic through https://clickup.com/api, I stumbled across some code. There are a couple of different ones for different things, I'd recommend the first, JavaScript (as that's whats closest to what your currently doing). In a comment you said it was for editing tasks so that's what this code is aimed for.

javascript

Just use an if statement in your PHP to check if your variables exist before you use them, and if they are undefined then you can deal with that error in a cleaner fashion.

You can do one thing here. Enable http to https redirection on cloudflare and create a worker rule to redirect non www to www..com. It might be ingress redirect rule causing the issue(nginx.ingress.kubernetes.io/from-to-www-redirect: "true").

If it still not work, then disbale http to https redirection, auto rewriting from cloudflare and disable SSL(off) as well for few minutes. Then check if site is working properly on http only.

Please Check and let me know for further troubleshooting

devicePath should be a path to the device (i.e. barcode scanner) on your RPi. It seems that you have set this to some file called device.py. Try following the instructions Here to get a list of available devices then use that device path as devicePath.

If you look at the examples on the page I referenced, you'll see that a devicePath should look like /dev/input/event1 or something. Not a file path.

Have a look at join logic for the database, if you join on a column you can take those that are the same (contains) or those that null (does not contain) there are different types of joins that can be used in combination with a where statement and in your homework assignment your mentors likes you to understand and apply them.

Open google and look at joins, or look at this https://www.w3schools.com/sql/sql_join.asp

If ecode has no index on it, then the two are different. Both result in table scans but the top (1) should short-circuit one of those scans, stopping at the first record that matches.

If ecode has an index -- or is declared unique -- there is probably no discernible difference. If there are duplicates, then the top (1) should stop at the first match. In that case, though, the queries would be different and you should choose the version you want.

If this code is in an exists or not exists, there is no difference, because those operators stop at the first matching row.

This would be true as well if ecode were a primary key.

Primary keys are implemented (mostly) by using unique indexes. The where clause will use the index to fetch the result. Explicitly limiting the results to a single row is not needed because the index has only one row for the matching value.

To use libraries to calculate distances you need to be on unified system. From google I believe you are using epsg:21781

1. first standardise co-ordinate system using pyproj
2. do a Cartesian product of colors and shapes
3. calculate distance between these using geopy
4. you can now select out resulting rows that you want. For purpose of example I've taken nearest when groups by color and shape

This is not a complete answer, but most of your file seems to look correct when it is un-escaped and printed out. For example, simply copy-pasting from your decoded.txt file into a python REPL and printing it out produces: