q issues

Error: new-line character seen in unquoted field

1

Whenever I try running a query against a CSV file, i get the following error: Error('new-line character seen in unquoted field - do you need to open the file in...

databasedude

Inconsistent results depending on the contents of the datafile.

6

Hi, I think this is a great idea! I tried to use "q", though I got inconsistent results with different text files: C:\Users\barryc\Desktop\>"C:\Program Files (x86)\q-TextAsData\q.exe" -H -d, "select Timestamp,Entity,max(Value) from...

barrycforever

Can't run nested subquery

3

Hi, Running a query like this: `SELECT c1 FROM (SELECT c1,sum(c2) FROM result.txt GROUP BY c1) ` results in this error: `No files matching '(SELECT' have been found ` Any...

aghasemi

added setup.py file so that we can install 'q' directly from git or pypi...

6

Hi Harel, just in case you don't mind I have added a setup.py file to your q package. This way it is possible to directly install q from github with...

ralhei

Escaping dynamic queries as string literals

2

For example, the query > SELECT name FROM queries.csv WHERE query = 'DELETE FROM dictionary' throws the error : file dictionary cannot be found. Is there a way to escape...

hazemkmammu

Need some indication when -t overrides -d and -T overrides -D

1

The -t shorthand parameters override specific -d delimiter setting without issuing any indication. This might lead to confusion. Same for output delimiters. A warning needs to be added in such...

harelba

Provide a python api + PyPI package for q

21

Use `if name == '__main__'` for standard command line usage in script. This would also allow to test the code itself.

fizyk

support for UTF-16LE encoding

6

Some CSV files are encoded in UTF-16LE, so they can be correctly read by M$ Excel But `q` fails when reading them: ``` $ q -H -t -e "UTF-16LE" "select...

Fil