class_docstr: Tests pertaining to our Pinot database support
class_docstr_tok: ["Tests","pertaining","to","our","Pinot","database","support"]
code: def test_pinot_time_expression_sec_one_1m_grain(self):
      col = column("tstamp")
      expr = PinotEngineSpec.get_timestamp_expr(col, "epoch_s", "P1M")
      result = str(expr.compile())
      expected = (
          "CAST(DATE_TRUNC('month', CAST("
          + "DATETIMECONVERT(tstamp, '1:SECONDS:EPOCH', "
          + "'1:SECONDS:EPOCH', '1:SECONDS') AS TIMESTAMP)) AS TIMESTAMP)"
      )
      self.assertEqual(
          result,
          expected,
      )
  
file_path: superset/tests/integration_tests/db_engine_specs/pinot_tests.py
imports: from sqlalchemy import column
  from superset.db_engine_specs.pinot import PinotEngineSpec
  from tests.integration_tests.db_engine_specs.base_tests import TestDbEngineSpec
label_desc: Use image node_id 5 for calling the TestPinotDbEngineSpec obj's underlying member method code with example usage: obj.test_pinot_time_expression_sec_one_1m_grain() without return types