I have a dataset looks like this: Link_number Houband Time Mean_speed Sample_Number Link 1 8 8:00 52 2 Link 1 8 8:30 55 5 Link 2 9 9:00 20 3 Link 2 9 9:30 40 4 I need to do…
I am trying to replace the value of one of the columns in the SELECT result to 0. Normally I can do: SELECT 0 AS column_to_set, other_col_1, other_col_2, ... FROM tbl However, there are lots of "other_cols" in the source…
I am trying to multiply the existing value with some constant value o.1876. the output of the data is looks like sales_agg 0.01314717 1.46E-04 0.00236974 0.02031013 0.01421709 0.25651208 0.10146865 0.00435217 0.01827912 0.12998486 i just need to mutiply the constant values…
I have a Athena SQL Query where I am calculating some delivery date like below. CASE WHEN eventtime IS NOT NULL AND eventtime != '' THEN date_format(from_iso8601_timestamp (eventtime), '%Y-%m-%d %H:%i:%s') ELSE NULL END AS computation_date When I download the data…
I have some Athena databases which contain a number of tables, and I know some of these tables use the Iceberg format. It's important to me to know which are Iceberg tables, because those will allow a greater range of…
I have a main table, Table 1, that includes columns for student ID and some other info. There is also Table 2 which includes columns for student ID, survey question, and response. Essentially, I want to append Table 2 to…
We are trying to optimise AWS S3. The cost explorer shows very high cost of ListBuckets calls. To get the source of these calls, we enabled the CloudTrails with configuration to log all the management and data eventtype logs for…
My organization stores long term data in multiple S3 buckets. Given that the data format is consistent across the different regions, I would like to create one table that I can query with Athena, rather than specifying the particular bucket.…
I'm running the following sql in Athena to create a partition ALTER TABLE database.table ADD PARTITION (partitionone='123', partitiontwo='456') LOCATION 's3://<s3-bucket>/data/partitionone=123/partitiontwo=456'; but I'm getting an error Query type not supported by Athena Iceberg at this time I've tried running MSCK REPAIR…
I am trying to select domain name from an email address using Athena but my noob glasses cant find the translation that works. As per my understanding the following should work but the required functions are missing in Athena (SUBSTRING_INDEX(SUBSTR(sd_ccode,…