1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
| span sql
help
use /span/xxxx/cloud-example-domain:test;
set dml_concurrency interactive_transactional;
select Device from Devices where Device.name like '%foo-%';
select device.region,device.area,device.name from Devices where device.id in ('bar','foo')
order by region,area,cast(ltrim(d.name, 'apple') as int32) desc limit 3;
select distinct Device.reference_id from Devices where "example_id" in UNNEST(Device.ids) limit 1;
select Device.id,timestamp_seconds(Metadata.last_updated_timestamp.seconds) from Devices where Metadata.last_updated_timestamp.seconds >= UNIX_SECONDS(TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 9 HOUR)) and Metadata.last_updated_timestamp.seconds < UNIX_SECONDS(TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 8 HOUR))
select Device.id from Devices where array_length(Device.ids) > 1;
select Device.service_level,count(*) from Devices where Device.type='SWITCH' group by Device.service_level;
insert into ProjectMappings(ProjectMapping, Metadata) values( {project_number: 1357913579, billing_account: "test-billing-account", project_state: "PROJECT_STATE_ACTIVE", alias: "test-alias" }, { last_updated_timestamp: {seconds: 1689901201}, version_id: 1555444333222111000, state: "LATEST", created_by: "example@gmail.com" } );
SELECT * from PrivateCloudMetadata WHERE PrivateCloud.region in ('us-east4', 'us-central1') AND Metadata.last_updated_timestamp.seconds > UNIX_SECONDS(TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 5 DAY));
|