Currently array_position only returns the first occurrence of the given element. We want to extend array_position to take an additional parameter instance similar to strpos.

array_position(x, element, instance) -> bigint

For example, for array x: [1, 3, 2, 1, 4, 3, 2, 5, 4, 1]:

array_position(x, 1) = 1 -- existing function
array_position(x, 1, 1) = 1 -- same as exist

If I were to deploy cube.js using AWS serverless architecture, is athena required?

The docs https://cube.dev/docs/deployment#serverless do not mention whether Athena is optional or required. But when reading it, I assume it is required because there are athena keys in the serverless.yml config. I'm evaluating the idea of using Postgres RDS as the sole datasource for cubejs.

Page
https://docs.alluxio.io/os/user/stable/en/deploy/Running-Alluxio-On-Docker.html

Summary
Two environment variables are not documented, and have negative impact when running Alluxio purely as a local disk cache via docker containers.

• ALLUXIO_WORKER_TIEREDSTORE_LEVEL0_DIRS_PATH
• ALLUXIO_RAM_FOLDER

If neither of these environment variables is set, and the docker container i

I think the new argument in the init function in presto.py was meant to be principal_username not principle_username.

Might need to wait for a major version change as it's a breaking one. Or to add the principal_username argument, deprecate the old one and wait for the major version to remove it.

https://github.com/dropbox/PyHive/blob/bbf79418cfd2806fd9079893e70acc50a727a65d/pyhi

CHAR is mapped to Kudu string
https://github.com/prestosql/presto/blob/ec549ac8a1192b18c3667203974f453d5fe5a9fa/presto-kudu/src/main/java/io/prestosql/plugin/kudu/TypeHelper.java#L88-L89

but char(3) value ab⎵ is not persisted as such, it's stored as ab instead.

I'm guessing that this my have to do with array types since both fields are of type array(varchar(66))

SQL

select block_transactions, block_uncles from ethereum.default.block limit 1;

When using Quix along other systems to manage SQL queries, we find ourselves often copy-pasting queries to and from Quix. It could be really nice if we could integrate Quix more seamlessly with our other systems. 2 ways of doing so are:

1. Opening Quix with a link that would allow creating a new note with parameters, something like `https://quix-url/notebook/6c7c0bc-0b84-49f4-bf8a-d6fc1c6c8b4b?ne

It'd be great to be able to successfully say we can parse all TPC-H queries without error.

A list of the ones presto uses (with some additional presto-specific stuff):
https://github.com/prestodb/presto/tree/master/presto-parser/src/test/resources/tpch/queries

2018-06-18T15:23:36.415Z        INFO    main    com.facebook.presto.server.PluginManager        Registering connector sqlserver
2018-06-18T15:23:36.417Z        INFO    main    com.facebook.presto.server.PluginManager        -- Finished loading plugin /var/groupon/presto/data/plugin/sqlserver --
2018-06-18T15:23:36.417Z        INFO    main    com.facebook.presto.server.PluginManager        -