You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@eduohe : Agreed with @gabe Hamilton that we will breakdown per ActionType instead of method name.
Change from this:
SELECT
receipt_receiver_account_id as receiver_id,
block_date,
args:method_name as method_name,
collect_list(block_height) as block_heights
FROM hive_metastore.mainnet.silver_action_receipt_actions
WHERE action_kind = 'FUNCTION_CALL'
AND block_height >= '{df_boundaries["first_indexed_block"]}'
AND block_height <= '{df_boundaries["last_indexed_block"]}'
GROUP BY receiver_id, block_date, method_name
ORDER BY receiver_id, block_date, method_name
to this:
SELECT
receipt_receiver_account_id as receiver_id,
block_date,
action_kind,
collect_list(block_height) as block_heights
FROM hive_metastore.mainnet.silver_action_receipt_actions
WHERE block_height >= '{df_boundaries["first_indexed_block"]}'
AND block_height <= '{df_boundaries["last_indexed_block"]}'
GROUP BY receiver_id, block_date, action_kind
ORDER BY receiver_id, block_date, action_kind
Generate index files that enumerate blocks for all contract actions: Transfer, AddKey, etc
Action list https://github.com/near/nearcore/blob/bf526b5a037187185c75d810557763de829d2317/runtime/near-vm-runner/src/logic/action.rs#L164
The text was updated successfully, but these errors were encountered: