presto-CodePudding

Tags > presto

09-15OSHow to get distinct values when year, month, day of date are stored in different columns
09-15OSprestodb: simple IF condition to create a column
09-13databaseConvert nested array of array to nested array of object
09-09databaseChange timestamp format in AWS Athena
09-07databaseAWS Athena (Presto) ' ' cannot be applied to varchar, varchar error
09-07databaseCompare values in list of Json - Presto
09-06databaseHow to check Trino version with SQL query?
09-01Enterprisehow to aggregate one record multiple times based on condition
08-31OSJSON_Extract from list of json string
08-30Software designHow to produce the following output in SQL
08-30Software designPRESTO SQL count group by date
08-30Software designselect rows with condition of date presto
08-29NetHow to compare and show if any changes in historical data in AWS Athena?
08-28Software engineeringGrab Latest Data Based on String
08-27OSSql:Sum of row values in columns
08-26OSHow to filter query in SQL conditionally?
08-25OSIn SQL, how do you count if any rows in a group match a certain criteria?
08-20front endSelect all columns except one when joining two tables in AWS Athena
08-19NetAWS Athena query struct property in array
08-18OSUsing the results of one SQL query in another query (Athena)
08-13EnterprisePresto - How to convert a field with map<string,string> to rows
08-12BlockchainGetting records between current date and next x days in Presto
08-11Enterprisesql json extract scalar with different keys in json
08-11Enterprisestarts_with in presto?
08-11BlockchainStrings of arrays and maps?
08-10front endPostgreSQL to PrestoSQL
08-08Back-endExplode a row into multiple rows based on a column value presto
08-04Software engineeringAthena Prepared Statement Parameter Order
08-04Software engineeringPresto substr operations: Split and return the first 3 element
08-04Software designHow to convert bigint into timestamp in Presto SQL?
08-03MobileGet JSON object keys as array in Presto/Trino
07-30OSExtracting a string from a nested dictionary in presto
07-28Software engineeringRolling distinct count for last 3 days (Presto DB)
07-27otherRegex that works on Athena does not work in spark-sql
07-26otherSQL Join tables based on matching max value
07-25Back-endExtract results from Presto in the form of JSON
07-22Enterpriselike query count does not match
07-20NetIs there any way to extract value list from map in presto query?
07-19Software designIs there a way to sort month and year string in google sheet or presto sql?
07-18databaseFilter only elements that matches a regex in Athena

163 1 2 3 4 5 Next Last