Re: Create external table with partitions using sqlContext.createExternalTable

it is a good to be in control :) Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 14 June 2016 at 13:06

Re: Create external table with partitions using sqlContext.createExternalTable

Thanks, yes I have something similar working as "the alternative solution". :) I was hoping to get away with not having to specify my schema so the sqlContext.createExternalTable seemed like a nice clean approach. 2016-06-14 13:59 GMT+02:00 Mich Talebzadeh : > Try this this will work > > sql("us

Re: Create external table with partitions using sqlContext.createExternalTable

Try this this will work sql("use test") sql("drop table if exists test.orctype") var sqltext: String = "" sqltext = """ CREATE EXTERNAL TABLE test.orctype( prod_id bigint, cust_id bigint, time_id timestamp, channel_id bigint, promo_id bigint, q