合并日期，hits.hour和hits.minute字段

您只需要串联选定的值

SELECt     fullVisitorId,    visitId,    CAST(date as string) +' & ' + CAST (hits.hour as string) + ':' + CAST (hits.minute as string) AS datetime,    totals.transactions ,    hits.item.productName,FROM [X.ga_sessions_20180221] WHERe     hits.hitNumber =1GROUP BY   fullVisitorId, visitId, date, hour, minute, hits.item.productName, totals.transactions