Access Table List

num_int = 123
num_str = "456"

print("Data type of num_int:",type(num_int))
print("Data type of num_str before Type Casting:",type(num_str))

num_str = int(num_str)
print("Data type of num_str after Type Casting:",type(num_str))

num_sum = num_int + num_str

print("Sum of num_int and num_str:",num_sum)
print("Data type of the sum:",type(num_sum))

try_cast(o.grass_date as date) grass_date,
try_cast(itemid as bigint) item_id,

vnbi_fpna.shopee_vn_bi_team__monthly_voucher_deal_airpay
vnbi_fpna.shopee_vn_bi_team__airpay_collection_sponsor_data

array_sort(
  array_distinct(
    regexp_extract_all(
      lower(it.name)
      ,'\bkhô gà\b|\bhạt điều rang muối\b|\bda cá\b'
    )))

import java.util.*;
import java.io.*;
  
class Test {
    
    public static class MinHeap
    {
        int arr[];
        int size;
        int capacity;
        
        MinHeap(int c){
        size = 0; 
        capacity = c; 
        arr = new int[c];
        }
    
        int left(int i) { return (2*i + 1); } 
        int right(int i) { return (2*i + 2); } 
        int parent(int i) { return (i-1)/2; } 
    
    
        public void insert(int x) 
        { 
            if (size == capacity)return;
            size++; 
            arr[size-1]=x; 
         
            for (int i=size-1;i!=0 && arr[parent(i)]>arr[i];) 
            { 
                int temp = arr[i]; 
                arr[i] = arr[parent(i)]; 
                arr[parent(i)] = temp; 
                i = parent(i); 
            } 
        }
    
        public void minHeapify(int i) 
        { 
            int lt = left(i); 
            int rt = right(i); 
            int smallest = i; 
            if (lt < size && arr[lt] < arr[i]) 
                smallest = lt; 
            if (rt < size && arr[rt] < arr[smallest]) 
                smallest = rt; 
            if (smallest != i) 
            { 
                int temp = arr[i]; 
                arr[i] = arr[smallest]; 
                arr[smallest] = temp; 
                minHeapify(smallest); 
            } 
        }
    
        public int extractMin() 
        { 
            if (size <= 0) 
                return Integer.MAX_VALUE; 
            if (size == 1) 
            { 
                size--; 
                return arr[0]; 
            }  
            int temp = arr[0]; 
            arr[0] = arr[size-1]; 
            arr[size-1] = temp;
            size--; 
            minHeapify(0); 
          
            return arr[size]; 
        } 
        
    }
    
    public static void main(String args[]) 
    { 
        MinHeap h=new MinHeap(11);
        h.insert(3); 
        h.insert(2);
        h.insert(15);
        h.insert(20);
        System.out.print(h.extractMin());     // OUTPUT : 2
    } 
} 

date_add('day',-1,current_date)

 date(split(o.create_datetime, ' ')[1])

select           cast(campaign_date as date) as spikedate
                ,case when cast(campaign_date as date) = date'2021-11-11' then '1111'
                      when is_big_campaign =  '1' and cast(campaign_date as date) <> date'2021-11-11' then 'Spike'
                      when is_big_campaign =  '0'  then 'Mini Spike' end as SpikeFlag
from            vnbi_bd.clusterbi_spike_days
where           ingestion_timestamp = (select max(ingestion_timestamp) m from shopee_vn.shopee_vn_bi_team__fmcgbi_campaign_day)
                and cast(campaign_date as date) >= date'2020-10-10'