1-- 2-- Copyright 2019 The Android Open Source Project 3-- 4-- Licensed under the Apache License, Version 2.0 (the "License"); 5-- you may not use this file except in compliance with the License. 6-- You may obtain a copy of the License at 7-- 8-- https://www.apache.org/licenses/LICENSE-2.0 9-- 10-- Unless required by applicable law or agreed to in writing, software 11-- distributed under the License is distributed on an "AS IS" BASIS, 12-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13-- See the License for the specific language governing permissions and 14-- limitations under the License. 15-- 16 17DROP TABLE IF EXISTS {{table_name}}_unagg_values; 18 19CREATE TABLE {{table_name}}_unagg_values AS 20SELECT 21 upid, 22 RepeatedField( 23 AndroidMemoryUnaggregatedMetric_Value( 24 'ts', ts, 25 'oom_score', oom_score_val, 26 'value', {{table_name}}_val 27 ) 28 ) as metric 29FROM {{table_name}}_by_oom_span 30GROUP BY upid; 31