Vikas, You are bounded by database used by metastore which usually is mysql. On a modern machine, mysql easily scales for few millions of rows, so I will expect that you should be able to create atleast those many tables.
Thanks, Ashutosh On Wed, Aug 24, 2011 at 03:45, Chinna <chinna...@huawei.com> wrote: > Hi,**** > > ** ** > > Any number of tables u can create and as of i know there is no > configuration to set the max no of tables.**** > > ** ** > > Thanks**** > > Chinna Rao Lalam**** > > ** ** > ------------------------------ > > *From:* Vikas Srivastava [mailto:vikas.srivast...@one97.net] > *Sent:* Wednesday, August 24, 2011 1:54 PM > *To:* user@hive.apache.org > *Subject:* Maximum Nos of table in hive**** > > ** ** > > hey folks. > > can any1 tell me that how many tables are allowed in hive. > > Is dere any limit or cofiguration through which we can set the max no of > tables in hive. > > > > -- > With Regards > Vikas Srivastava > > DWH & Analytics Team**** > > Mob:+91 9560885900 > One97 | Let's get talking !**** > > ** ** >
