Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Database limits for Hive

Copy link to this message
Re: Database limits for Hive
Hi Farah,
#2 and #4 should be easy to figure by taking a look at the metastore
scripts. For example, I took a quick look at
and it seems like 128 is the answer to #4

#1 and #3 I am not entirely sure. I am not sure of any such
restriction for #1. For #3 your best bet is to look at the ODBC driver


On Mon, Dec 17, 2012 at 11:48 AM, Omer, Farah <[EMAIL PROTECTED]> wrote:
> Hi,
> Does anyone know of the SQL limits for Hive? Particularly the following:
> 1.      The maximum number of tables in join, aka, the maximum number of tables in a select query
> 2.      The maximum number of columns in creating an index
> 3.      Maximum size of SQL string accepted by ODBC driver
> 4.      The maximum length of a column name
> Any insight much appreciated.
> Thanks.
> Farah