[
https://issues.apache.org/jira/browse/DRILL-7786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190624#comment-17190624
]
Shivam Saxena commented on DRILL-7786:
--------------------------------------
I am getting below error while starting drill in distributed mode (although
1.17 was working fine on the same servers):-
{color:#de350b}Exception in thread "main"
org.apache.drill.exec.exception.DrillbitStartupException: Failure during
initial startup of Drillbit.{color}
{color:#de350b} at
org.apache.drill.exec.server.Drillbit.start(Drillbit.java:588){color}
{color:#de350b} at
org.apache.drill.exec.server.Drillbit.start(Drillbit.java:554){color}
{color:#de350b} at
org.apache.drill.exec.server.Drillbit.main(Drillbit.java:550){color}
{color:#de350b}Caused by:
org.apache.drill.common.exceptions.DrillRuntimeException: unable to put {color}
{color:#de350b} at
org.apache.drill.exec.coord.zk.ZookeeperClient.putIfAbsent(ZookeeperClient.java:326){color}
{color:#de350b} at
org.apache.drill.exec.store.sys.store.ZookeeperPersistentStore.putIfAbsent(ZookeeperPersistentStore.java:119){color}
{color:#de350b} at
org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.prepareStores(RemoteFunctionRegistry.java:201){color}
{color:#de350b} at
org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.init(RemoteFunctionRegistry.java:108){color}
{color:#de350b} at
org.apache.drill.exec.server.Drillbit.run(Drillbit.java:233){color}
{color:#de350b} at
org.apache.drill.exec.server.Drillbit.start(Drillbit.java:584){color}
{color:#de350b} ... 2 more{color}
{color:#de350b}Caused by:
org.apache.zookeeper.KeeperException$UnimplementedException: KeeperErrorCode =
Unimplemented for /drill/udf/registry{color}
{color:#de350b} at
org.apache.zookeeper.KeeperException.create(KeeperException.java:106){color}
{color:#de350b} at
org.apache.zookeeper.KeeperException.create(KeeperException.java:54){color}
{color:#de350b} at
org.apache.zookeeper.ZooKeeper.create(ZooKeeper.java:1637){color}
{color:#de350b} at
org.apache.curator.framework.imps.CreateBuilderImpl$17.call(CreateBuilderImpl.java:1180){color}
{color:#de350b} at
org.apache.curator.framework.imps.CreateBuilderImpl$17.call(CreateBuilderImpl.java:1156){color}
{color:#de350b} at
org.apache.curator.connection.StandardConnectionHandlingPolicy.callWithRetry(StandardConnectionHandlingPolicy.java:67){color}
{color:#de350b} at
org.apache.curator.RetryLoop.callWithRetry(RetryLoop.java:81){color}
{color:#de350b} at
org.apache.curator.framework.imps.CreateBuilderImpl.pathInForeground(CreateBuilderImpl.java:1153){color}
{color:#de350b} at
org.apache.curator.framework.imps.CreateBuilderImpl.protectedPathInForeground(CreateBuilderImpl.java:607){color}
{color:#de350b} at
org.apache.curator.framework.imps.CreateBuilderImpl.forPath(CreateBuilderImpl.java:597){color}
{color:#de350b} at
org.apache.curator.framework.imps.CreateBuilderImpl.forPath(CreateBuilderImpl.java:51){color}
{color:#de350b} at
org.apache.drill.exec.coord.zk.ZookeeperClient.putIfAbsent(ZookeeperClient.java:318){color}
{color:#172b4d}What zookeeper version is compatible with drill 1.18? I am
having 3.4.11 which was working fine with drill 1.17{color}
> Apache drill fails to execute when excel file has datetime column
> -----------------------------------------------------------------
>
> Key: DRILL-7786
> URL: https://issues.apache.org/jira/browse/DRILL-7786
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Other
> Affects Versions: 1.17.0
> Reporter: Shivam Saxena
> Priority: Blocker
> Fix For: 1.18.0
>
> Attachments: excel_date_testing.csv, excel_date_testing.xlsx
>
>
> I am getting below error when m trying to query an excel sheet having
> datetime column in it. While when we convert same excel sheet to csv, its
> working fine.
> {color:#FF0000}org.apache.drill.common.exceptions.UserRemoteException:
> EXECUTION_ERROR ERROR: No instant converter found for type: java.lang.Double
> Read failed for reader ExcelBatchReader Fragment 0:0 [Error Id:
> 0d8bf3b7-d6f3-4a12-8633-eb10a36cc6cb on 192.168.1.20:31010]{color}
> {color:#172b4d}Attaching the sample excel sheet and converted csv file for
> reference.{color}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
