benchto icon indicating copy to clipboard operation
benchto copied to clipboard

SQL is not an update statement exception

Open kokosing opened this issue 8 years ago • 0 comments

See:

00:16:57.976 Exception in thread "defaultTaskExecutor-1" 06:45:10.548 ERROR [defaultTaskExecutor-2] c.t.b.d.l.LoggingBenchmarkExecutionListener - Query failed: q15 (0/6), execution error: SQL is not an update statement: /* TPC_H Query 15 - Create View for Top Supplier Query */
00:16:57.976 WITH revenue0 AS (
00:16:57.976 SELECT
00:16:57.976 l.suppkey as supplier_no,
00:16:57.976 sum(l.extendedprice*(1-l.discount)) as total_revenue
00:16:57.976 FROM
00:16:57.976 "hive"."tpch_10gb_orc"."lineitem" l
00:16:57.976 WHERE
00:16:57.976 l.shipdate >= DATE '1996-01-01'
00:16:57.976 AND l.shipdate < DATE '1996-01-01' + INTERVAL '3' MONTH
00:16:57.976 GROUP BY
00:16:57.976 l.suppkey
00:16:57.976 )
00:16:57.976 
00:16:57.976 /* TPC_H Query 15 - Top Supplier */
00:16:57.976 SELECT
00:16:57.976 s.suppkey,
00:16:57.976 s.name,
00:16:57.976 s.address,
00:16:57.976 s.phone,
00:16:57.976 total_revenue
00:16:57.976 FROM
00:16:57.976 "hive"."tpch_10gb_orc"."supplier" s,
00:16:57.976 revenue0
00:16:57.976 WHERE
00:16:57.976 s.suppkey = supplier_no
00:16:57.976 AND total_revenue = (SELECT max(total_revenue) FROM revenue0)
00:16:57.976 ORDER BY
00:16:57.976 s.suppkey

kokosing avatar Sep 22 '16 11:09 kokosing