Tag Archives: sql

SQL Scratch

These are just scratches/notes for my work with Prestashop select id_product, reference from ps_product where reference like ‘9254050’ limit 10; Uppercase first letter only on string, and lowercase the others (remove any spaces infront or at the end)select name, concat(upper(left(name,1)),lower(substring(name,2,length(name)))) … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Apache SPARK and Cassandra and SQL

This is a short intro to start using Apache SPARK with Cassandra, running SQL on the Cassandra tables. Note that I am not running a SPARK cluster, I am running “local”, to me this is really convenient, not having to … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 2 Comments