2015 at 10:46 PM, Ravisankar Mani
> wrote:
>
>> Hi Everyone,
>>
>>
>> In MSSQL server suppprt "ISDATE()" function is used to fine current
>> column values date or not?. Is any possible to achieve current column
>> values date or not?
>>
>>
>> Regards,
>> Ravi
>>
>
>
Hi Everyone,
In MSSQL server suppprt "ISDATE()" function is used to fine current column
values date or not?. Is any possible to achieve current column values date
or not?
Regards,
Ravi
Hi everyone,
Can you please share optimized query for pagination spark sql?
In Ms SQL Server, They have supported "offset" method query for specific
row selection.
Please find the following query
Select BusinessEntityID,[FirstName], [LastName],[JobTitle]
from HumanResources.vEmployee
Order By
Hi,
Exception thrown when using Having Clause with variation or stddev. It
works perfectly when using other aggregate functions(Like
sum,count,min,max..)
SELECT SUM(1) AS `sum_number_of_records_ok` FROM
`some_db`.`some_table` `some_table`
GROUP BY 1 HAVING (STDDEV(1) > 0)
SELECT SUM(1) AS `sum_
Hi all,
I got an exception like
“org.apache.spark.sql.catalyst.analysis.UnresolvedException: Invalid call
to dataType on unresolved object” when using some where condition queries.
I am using 1.4.0 version spark. But its perfectly working in hive .
Please refer the following query. I have appli
Hi Josh
Please ignore the last mail stack trace. Kindly refer the exception details.
{"org.apache.spark.sql.catalyst.analysis.UnresolvedException: Invalid call
to dataType on unresolved object, tree: 'Sheet1.Teams"}
Regards,
Ravi
On Wed, Aug 12, 2015 at 1:34 AM, Ravisankar Man
ardsamples\wcf\DashboardService.svc.cs:line
1269
Regards,
Ravi
On Tue, Aug 11, 2015 at 11:53 PM, Josh Rosen wrote:
> Can you share a query or stack trace? More information would make this
> question easier to answer.
>
> On
Hi all,
We got an exception like
“org.apache.spark.sql.catalyst.analysis.UnresolvedException: Invalid call
to dataType on unresolved object” when using some where condition queries.
I am using 1.4.0 version spark. Is this exception resolved in latest spark?
Regards,
Ravi
Hi everyone
I have tried to to achieve hierarchical based (index mode) top n creation
using spark query. it taken more time when i execute following query
Select SUM(`adventurepersoncontacts`.`contactid`) AS
`adventurepersoncontacts_contactid` ,
`adventurepersoncontacts`.`fullname` AS `adventur
Hi Everyone,
As mentioned in Spark sQL programming guide, Spark SQL support Hive UDFs.
I have built the UDF's in hive meta store. It working perfectly in hive
connection. But it is not working in spark ("java.lang.RuntimeException:
Couldn't find function DATE_FORMAT").
Could you please help how t
Hi everyone,
I have planned to move mssql server to spark?. I have using around 50,000
to 1l records.
The spark performance is slow when compared to mssql server.
What is the best data base(Spark or sql) to store or retrieve data around
50,000 to 1l records ?
regards,
Ravi
Hi everyone,
More time to be taken when i execute query using (group by +
order by) or (group by + cast + order by) in same query. Kindly refer the
following query
Could you please provide any solution regarding thisd performance issue?
SELECT If(ISNOTNULL(SUM(CAST(adventurepers
Hi everyone,
I can't get 'day of year' when using spark query. Can you help any way to
achieve day of year?
Regards,
Ravi
Hi everyone,
I can't get 'day of year' when using spark sql query. Can you help any way
to achieve day of year?
Regards,
Ravi
14 matches
Mail list logo