Re: Union all with a field 'hard coded'

Perfect. Thank you Xuefu. Philippe On Fri, Jan 30, 2015 at 11:32 PM, Xuefu Zhang wrote: > Use column alias: > > INSERT OVERWRITE TABLE all_dictionaries_ext > SELECT name, id, category FROM dictionary > UNION ALL SELECT NAME, ID, "CAMPAIGN" as category FROM md_campaigns > > > On Fri,

Re: Union all with a field 'hard coded'

Xuefu, should this be documented in the Union wikidoc ? Is it relevant for other query clauses? -- Lefty On Sun, Feb 1, 2015 at 11:27 AM, Philippe Kernévez wrote: > Perfect. > > Thank you Xuefu. > > Philippe > > On Fri, Jan

Re: Which [open-souce] SQL engine atop Hadoop?

i would not exclude spark sql unless you really need something mutable in which case lingual wont work either On Sat, Jan 31, 2015 at 8:56 PM, Samuel Marks wrote: > Interesting discussion. It looks like the HBase metastore can also be > configured to use HDFS HA (ex. tutorial >

Re: Which [open-souce] SQL engine atop Hadoop?

Well what I am seeking is a Big Data database that can work with Small Data also. I.e.: scaleable from one node to vast clusters; whilst maintaining relatively low latency throughout. Which fit into this category? Samuel Marks http://linkedin.com/in/samuelmarks

Re: Which [open-souce] SQL engine atop Hadoop?

Hallo, I think you have to think first about your functional and non-functional requirements. You can scale "normal" SQL databases as well (cf CERN or Facebook). There are different types of databases for different purposes - there is no one fits it all. At the moment, we are a few years away from