On Wed, Aug 24, 2011 at 7:32 PM, Ashutosh Chauhan <hashut...@apache.org>wrote:
> 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 !**** >> >> ** ** >> > > You are likely to run out NameNode memory with hadoop files and blocks well before hitting 1,000,000 tables.
