Hi all
I have checked that even my simplest query is not working
SELECT AAA FROM
dfs.'/user/olap/EntityProfiling/DomainParquet/Domain-1-_1481273732716/part-r-0-7c4b50c5-0318-4243-9f76-9822c02a566d.snappy.parquet';
Thanks
Manjeet
On Mon, Dec 26, 2016 at 11:26 AM, Manjeet Singh
wrote:
> Hi
Hi All,
I have query, I want to create table/ view on drill I have data stored in
parquet files on hdfs
i am using below command but not able to create table
CREATE TABLE 't'(
"AAA", "Domain", "certValidity", "protocol", "LastActive", "GetCount",
"PostCount", "Data_Transfer", "Data_Receiv
On Mon, Dec 26, 2016 at 11:17 AM, Manjeet Singh
wrote:
>
> please add me in mailing list
> --
> luv all
>
--
luv all
Alternatively, you can set the following configuration to false:
alter session set `planner.enable_nljoin_for_scalar_only` = false;
Cartesian joins need to be processed as a nested loop join, and by default,
Drill only considers nested joins in the case where at least one side of
the join is a sc
You can fake the limitation by adding a constant column to both tables, I
think, and then joining on the constant.
On Sun, Dec 25, 2016 at 2:04 PM, clhub...@gmail.com
wrote:
>
> I am trying to do a cross join to get a cartesian products.
>
> Per the error message (attached) and the JIRA ticket
I am trying to do a cross join to get a cartesian products.
Per the error message (attached) and the JIRA ticket I see it isn't
supported.
https://issues.apache.org/jira/browse/DRILL-3807
I wrote the query against using dfs on csv file types.
Can I execute a cross join in Apache Drill just by mo
On Sun, Dec 25, 2016 at 11:04 AM, Bob Rudis wrote:
> Drill SQL seems to not be as "standard" as it claims (some
> operations that are valid SQL after a series of dplyr transforms shld
> work but do not).
>
Can you elaborate? What operations?
Also, Drill claims that it is as compatible as poss
I'll be working on adding said functionality (data.frame to parquet)
in the near future (though the use-case is still a bit lost on me it's
not the first request for it I've seen). I just revamped the dplyr
interface (it's almost complete now apart from some details around
quoting). Drill SQL seems
