RE: drill error connecting to Hbase

This means that the connectivity with ZK appears to be working. What are the HBase, ZK and Hadoop versions that you are working with? I presume that the student table is otherwise accessible. -Original Message- From: Shai Shapira [mailto:shai.shap...@amdocs.com] Sent: Sunday, July 23,

Re: CTAS and save as parquet last column values are shown as null

0: jdbc:drill:zk=local> select * FROM dfs.`installedsoftwares/ApacheDrill/apache-drill-1.10.0.tar/apache-drill-1.10.0/sample-data/jll/data/mapping/PublicHoliday/PublicHoliday.csv` limit 10 ; +-+ | columns |

Re: CTAS and save as parquet last column values are shown as null

Pasting the result set in text format *Reading parquet file format :* > Day Date Area > Friday 15/1/2016 null > Tuesday 26/1/2016 null > Monday 7/3/2016 null > Friday 25/3/2016 null > Friday 1/4/2016 null > Friday 8/4/2016 null *Reading csv file format * > columns >

Re: CTAS and save as parquet last column values are shown as null

Unfortunately, the attachments / pictures haven't come through. Mailing lists sometimes do not support these. Can you paste as text or share links to it instead? On Sun, Jul 23, 2017 at 9:14 PM, Divya Gehlot wrote: > yes it shows the proper values when I query the csv

Re: CTAS and save as parquet last column values are shown as null

yes it shows the proper values when I query the csv file. CTAS query csv to parquet : Create table `dfs`.`tmp`.`publicholiday.parquet` AS SELECT CASE WHEN `Day` = '' THEN CAST(NULL AS VARCHAR(100)) ELSE CAST(`Day` AS VARCHAR(100)) END AS `Day`, CASE WHEN `Date` = '' THEN CAST(NULL AS VARCHAR(100))

kudu hash partition query error

Hi, When I query kudu throught drill ,I got an exception : NonRecoverableException: Invalid scan stop key: Error decoding composite key component 'metric': Missing separator after composite key string component. My create kudu table code as follow:

Re: CTAS and save as parquet last column values are shown as null

Can you share a sample row from the CSV and the CTAS query? Also test if a select columns[n] query on the CSV file works as expected [1] ? It could be an issue with delimiters. [1] https://drill.apache.org/docs/querying-plain-text-files/#columns[n]-syntax On Sun, Jul 23, 2017 at 8:44 PM Divya

CTAS and save as parquet last column values are shown as null

Hi , I am facing as weird issue when I CTAS and save the csv file as parquet it displays the last column values as null . This is not the case with one file . If I take any csv file with even with any data type and do a select column1,column2,column3 from table.parquet it shows the column3 values

RE: drill error connecting to Hbase

Hi, I installed Drill and started to work with it, my goal is to use it to connect to Hbase. I checked it a bit locally, csv files, Json files, works great. When I am trying to connect to Hbase, I am getting error. It seems that it is connecting to the Hbase/ZK, but fails somehow there. The